Mysql Login Problem !!!

Hi I am a stupid buyer of a plesk server with rackshack. The speed and server response has been ok but 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

 

 

 

 

Top