Recent content by groupedmx

Actually impossible for me to restore a backup. I redid a new server to compare with the existing: on the new here is the table: and on mine I only have that: it makes a lot of tables to recreate and so today the only way to launch the mysql is actually to add the skip-grant-tables

I actually tried to restore a backup of my base system 'mysql' from daily-dumps and preupgrade-dumps, but even the oldest backup contains this error (only a few tables on the set it should contain) . I had to have this problem for a long time without noticing it ... a 'plesk repair db' tells me...

I tested to do a "plesk repair mysql":

I made a snapshot of my seveur just in case ... but I do not know if I have to force the upgrade

I retested several times, I rebooted several times, redone the latest updates, everything seems OK except the my.cnf file in which I have to leave skyp-grant-tables to be able to start MySQL.

I have tried so many solutions that I do not really know what has been updated, but I do not think I made a direct update to MYSQL, but I do all the updates that are provided directly by PLESK

I have just done different tests, I put the bind-address in 0.0.0.0 and I manage to restart the MYSQL. But if I delete the line skip-grant-tables (which I added for my tests and which does not normally exist) can not restart.

what i do not understand is that the bind-address has always been on 0.0.0.0 before and it worked fine

just tested differently and it starts! But I'm afraid that by rebooting it will not crash again ...

already, I just saw a typo: 217 instead of 127! But even leaving only 127.0.0.1, mysql does not demmare

I don't have /etc/my.cnf but /etc/mysql/my.cnf

Nobody to help me? I am really stuck :-( Some new elements: By dint of testing things, I ended up modifying the file my.cnf at the level of the bind-address, adding 127.0.0.1 on the line which was however in 0.0.0.0 and there I managed to return! uncomfortable !! Then I made a reboot ... and...

Hello, Since an update, can not launch PLESK, and MYSQL service. I followed all the posts of the forum, but nothing helps. Could someone help me, I'm really embarrassed. Thank you