3 times the CP became unaccessible with the error message 'unable to connect to mysql with admin@localhost using password:YES'
I contacted the support and the 1st 2 times they made it work again, but this time they told me that mysql was corrupted and that I had to get the server restored ...
Luckely I have only got about 70 sites on it for the moment ...
With phpmyadmin all the databases that are owned but other users then the admin are accessible, just the psa database that is not.
I have got all my customer info in this file so I need to at least be able to make a dump.
I've tried to make a dump using ssh but no luck. In the end i got it to ask for a password, I entered it and it refused it.
The support say that my admin user does not exist anymore and maybe the root neither. I have tried following the instructions o the mysql pages for when you have forgotten your password with no success.
Is there another way of getting the information without doing a dump, where does mysql store its information, is there a way of making another user have all permissions etc ...

Please help I've got to get the restore done as soon as possible !!!

hoot

You need to shut down MySQL and start it up with the option
--skip-grant-tables --skip-networking
This will start MySQL in an insecure mode -- which is could be dangerous on a live system.

You then can change the root password back to something you know -- like "". Then restart MySQL in the normal way and use mysqladmin to change the password.

thanks but I managed to get it working with some help from forum.plesk.com

Hello... could you post the URL? We had similar problems with MySQL when the Plesk server first rolled out... I'm interested.

Here it is :
http://forum.plesk.com/showthread.php?post...11712#post11712
but we were out of luck, A bit of time later it stopped being able to create users then the admin user got deleted again so only solution : restore (the one thing that rackshack seem to be good at), well it's going to be done on friday, I hope all goes well this time ...