MySQL database failed! : SQL flush privile [FIXED]

5 posts / 0 new
Topic locked
Last post
#1 Fri, 02/13/2009 - 05:35
djjerdog

MySQL database failed! : SQL flush privile [FIXED]

MySQL database failed! : SQL flush privileges failed : Table 'mysql.servers' doesn't exist at ../web-lib-funcs.pl line 1305.

I am getting this error when trying to setup a new virtual server. It seems to have started after manually upgrading to MySQL 5.1 and PHP 5.2

CentOS 5.2 Virtualmin 3.65 Webmin 1.450

Post edited by: djjerdog, at: 2009/02/13 05:37

Post edited by: djjerdog, at: 2009/02/13 05:38<br><br>Post edited by: djjerdog, at: 2009/02/13 14:58

Fri, 02/13/2009 - 06:48
andreychek

Yeah, it doesn't sound like it upgraded correctly.

How did you go about upgrading? And what version of MySQL had you been using?

The program &quot;mysql_upgrade&quot; should be run when upgrading MySQL versions, but normally that would be done for you if using an RPM.

But, if you run &quot;mysql_upgrade&quot; manually, it should fix your issue.

To be safe, I'd recommend making a database backup first.
-Eric

Fri, 02/13/2009 - 11:46 (Reply to #2)
Joe
Joe's picture

Yes, this is a broken MySQL, probably due to skipping the necessary upgrade step Eric mentioned. Not much Virtualmin/Webmin can do for you here.

--

Check out the forum guidelines!

Fri, 02/13/2009 - 14:56
djjerdog

mysql_upgrade was exactly it!

I ran:
mysql_upgrade -u &quot;mysql admin account&quot; -p

works perfectly now, Thank you!

Tue, 11/23/2010 - 14:27
eddieb

helpful thread. i ran into several

Table upgrade required. Please do REPAIR TABLE or dump/reload to fix it

errors after doing mysql_upgrade. instead of fixing each table manually, i ran

mysqlcheck --check-upgrade --all-databases --auto-repair

and all the tables were fixed.

Topic locked