webmin 升级mysql_VITUALMIN/WEBMIN,升级MYSQL后,无法创建数据库

WEBMIN后台删除添加数据库报错提示信息：

MySQL database failed! : SQL flush privileges failed : Table 'mysql.servers' doesn't exist …

升级MYSQL(版本>5.0.9)后，无法创建数据库及用户，报错：

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

解决方法

# mysql_upgrade -u root -p "MYSQL-ROOT的密码"

如：# mysql_upgrade -uroot -p 123456

彻底解决！！

解决方法2执行后提示如下为正常：

Enter password:

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'

Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'

mysql.columns_priv                                 OK

mysql.db                                           OK

mysql.func                                         OK

mysql.help_category

error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!

mysql.help_keyword

error    : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it!

mysql.help_relation                                OK

mysql.help_topic

error    : Table upgrade required. Please do "REPAIR TABLE `help_topic`" or dump/reload to fix it!

mysql.host                                         OK

mysql.proc

error    : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it!

mysql.procs_priv                                   OK

mysql.tables_priv                                  OK

mysql.time_zone                                    OK

mysql.time_zone_leap_second                        OK

mysql.time_zone_name

error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" or dump/reload to fix it!

mysql.time_zone_transition                         OK

mysql.time_zone_transition_type                    OK

mysql.user                                         OK

Repairing tables

mysql.help_category                                OK

mysql.help_keyword                                 OK

mysql.help_topic                                   OK

mysql.proc                                         OK

mysql.time_zone_name                               OK

Running 'mysql_fix_privilege_tables'...

OK