Problem with Virtualmin and MySQL databases

4 posts / 0 new
Topic locked
Last post
#1 Fri, 11/28/2008 - 09:31
CaptainR

Problem with Virtualmin and MySQL databases

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

[code:1] Failed to save mailbox : SQL flush privileges failed : Table 'mysql.procs_priv' doesn't exist [/code:1]

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

Fri, 11/28/2008 - 10:34
andreychek

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

mysql_fix_privilege_tables --password=root_password

Fri, 11/28/2008 - 13:32 (Reply to #2)
CaptainR

That was precisely what the doctor ordered.

Thanks!!!

Mon, 08/23/2010 - 01:56
bizna

Helped here as well...

Thanks a bundle!

Topic locked