Table mysql.servers doesn’t exist: Problem adding a database user in plesk Or restarting mysql
Posted by Category: Linux Administration
Update: If “mysql_fix_privilege_tables” command does not exist, look at Section 2.
You may receive a “Table ‘mysql.servers’ doesn’t exist” error message while adding a database user in Plesk OR while restarting the Mysql service. The complete error message look like:
Error: Connection to the database server has failed: Table 'mysql.servers' doesn't exist
OR
Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
The problem mostly occurs when Mysql server is upgraded from an older to a newer version and the upgrade remains incomplete. Since Mysql often introduces new tables with the newer versions, you need to run the “mysql_fix_privilege_tables” script located in the “/usr/bin/” directory so the mysql database is updated with the latest contents thus fixing the privileges of the database users as well.
Section 1:
To fix the issue, SSH to your server as root and execute the command:
On a plain Linux OR Linux/cPanel server:
# mysql_fix_privilege_tables --user=root --password=<mysql password here> --verbose
On a Linux/Plesk server:
# mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow` --verbose
where, –verbose will display the detailed output.
Section 2:
If mysql_fix_privilege_tables command does not exist, use mysql_upgrade instead. mysql_fix_privilege_tables is an older script that previously was used to uprade the system tables in the mysql database after a MySQL upgrade. mysql_upgrade command have superseded mysql_fix_privilege_tables.
To fix the issue, you need to replace mysql_fix_privilege_tables with mysql_upgrade in the above stated commands, i.e.
On a plain Linux OR Linux/cPanel server:
# mysql_upgrade --user=root --password=<mysql password here> --verbose
On a Linux/Plesk server:
# mysql_upgrade --user=admin --password=`cat /etc/psa/.psa.shadow` --verbose
Tags: Can't open and lock privilege tables + restarting mysql, cannot add database user in plesk, mysql error while adding db user in plesk, mysql.servers message + restarting mysql service, mysql_fix_privilege_tables command to fix db user privileges, mysql_fix_privilege_tables: command not found, Table 'mysql.servers' doesn't exist, table mysql.servers error + adding db user in plesk
October 25th, 2010 at 9:21 am
Hi, thank you for help, but have still some problem … the command (for linux/plesk) doesnt work, can you help please ? :
# mysql_fix_privilege_tables -uxxx -pxxx-verbose
This script updates all the mysql privilege tables to be usable by the current version of MySQL
Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql –no-defaults –force –user=root –host=localhost –database=mysql
Please check the above output and try again.
Running the script with the –verbose option may give you some information
of what went wrong.
If you get an ‘Access denied’ error, you should run this script again and
give the MySQL root user password as an argument with the –password= option
October 27th, 2010 at 9:43 am
On a Linux/Plesk server, you need to use the Plesk admin password in the command. You can also use the command as follows:
# mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow` --verboseThis should definitely fix the problem.
March 13th, 2011 at 2:27 am
i hv problem & using captcha in my php registration form. but after fillup the registration form i got msg:
Table ‘raihanma_jogja.user’ doesn’t exist
user: raihanma_dhaka
Database: raihanma_jogja
i need solution. Can anybody help me…???
March 16th, 2011 at 9:11 am
Hello,
The error clearly indicates that the table ‘user’ does not exist in the “raihanma_jogja” database. Make sure you are using the correct database name, username/password. If they are correct, try installing the application again as the table may have not been created during the installation.
March 22nd, 2011 at 6:04 pm
Hi,
Thanks for the post!
I got this error message when trying to delete a domain in Plesk, and was stumped as to why the error was occurring.
Your suggestion fixed the problem!
Thanks a lot!
July 13th, 2011 at 12:18 pm
Just to say that the Plesk solution worked perfectly. Thanks.
September 16th, 2011 at 3:07 pm
This worked perfectly on Plesk 10.2 on CentOS 5.6. Thanks!