Plesk 9.X Upgrades : Table ‘mysql.procs_priv’ doesn’t exist

Plesk Upgrades to Plesk 9.X may result in MySQL errors while adding new Database user under Plesk. Error under Plesk...

Plesk Upgrades to Plesk 9.X may result in MySQL errors while adding new Database user under Plesk.

Error under Plesk :
Table ‘mysql.procs_priv’ doesn’t exist

You can also check the same error under command line :

mysql> flush privileges;
ERROR 1146 (42S02): Table ‘mysql.procs_priv’ doesn’t exist
mysql>

This can be fixed using below command. This will try to repair/ recreate the tables having issues.

cat /usr/share/mysql/mysql_fix_privilege_tables.sql | mysql --no-defaults --force --user=admin -p --host=localhost --database=mysql

Note: Before executing this command, make sure that you have taken the full backup of MySQL.

Hope this helps 🙂

Related Posts

1 COMMENTS

  1. January 14, 2010 03:26 Reply

    Hi,
    thank you very much.
    I’m using this post now. 🙂

Leave a reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.