We're suddenly getting the following error when attempting to make changes to user permissions with databases:

Code:

Failed to save mailbox : SQL flush privileges failed : Table 'mysql.procs_priv' doesn't exist

This happens if I try within Virtualmin (3.63 GPL) to allow a user access to a MySQL database.

I've tried restarting MySQL and Webmin, but there is no change to this problem.

Please help.

Chris

What happens if you run this command (after first making a full MySQL database backup):

mysql_fix_privilege_tables --password=root_password

That was precisely what the doctor ordered.

Thanks!!!