Mysql Problem

[Diatodan]

Hi,

I have updated to plesk 10.0.1 and updated php and Mysql.
However, I cannot create a database user anymore :
"Error: Connection to the database server failed:Table 'mysql.servers' doesn't exist".

Any suggestions?

Thanks

 

[IgorG]

You have corrupted "mysql" database. Try to recover it with usual mysql methods.

 

[Diatodan]

Fix

Ok thanks,

Here is what I used :
[root@server ~]# mysql_fix_privilege_tables --user=admin --password=<admin passord> --verbose

 

[atomicturtle]

If you upgraded to myql 5.1, you need to perform a few extra steps to finish the upgrade:

http://www.atomicorp.com/wiki/index.php/Mysql