Loading... <h4>WEBMIN后台删除添加数据库报错提示信息:</h4> <p>MySQL database failed! : SQL flush privileges failed : Table 'mysql.servers' doesn't exist … </p> <p>升级MYSQL(版本>5.0.9)后,无法创建数据库及用户,报错:</p> <p>MySQL database failed! : SQL flush privileges failed : Table 'mysql.servers' doesn't exist at ../web-lib-funcs.pl line 1305.</p> <p>解决方法</p> <p># mysql_upgrade -u root -p "MYSQL-ROOT的密码"</p> <p>如:# mysql_upgrade -uroot -p 123456</p> <p>彻底解决!!</p> <p>解决方法2执行后提示如下为正常:</p> <p>Enter password: <br />Looking for 'mysql' as: mysql <br />Looking for 'mysqlcheck' as: mysqlcheck <br />Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' <br />Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' <br />mysql.columns_priv                                 OK <br />mysql.db                                           OK <br />mysql.func                                         OK <br />mysql.help_category <br />error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it! <br />mysql.help_keyword <br />error    : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it! <br />mysql.help_relation                                OK <br />mysql.help_topic <br />error    : Table upgrade required. Please do "REPAIR TABLE `help_topic`" or dump/reload to fix it! <br />mysql.host                                         OK <br />mysql.proc <br />error    : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it! <br />mysql.procs_priv                                   OK <br />mysql.tables_priv                                  OK <br />mysql.time_zone                                    OK <br />mysql.time_zone_leap_second                        OK <br />mysql.time_zone_name <br />error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" or dump/reload to fix it! <br />mysql.time_zone_transition                         OK <br />mysql.time_zone_transition_type                    OK <br />mysql.user                                         OK</p> <p>Repairing tables <br />mysql.help_category                                OK <br />mysql.help_keyword                                 OK <br />mysql.help_topic                                   OK <br />mysql.proc                                         OK <br />mysql.time_zone_name                               OK <br />Running 'mysql_fix_privilege_tables'... <br />OK</p> Last modification:October 6, 2023 © Allow specification reprint Support Appreciate the author AliPayWeChat Like 如果觉得我的文章对你有用,请随意赞赏
One comment
很好了,学习了