mysql_upgrade-致命错误:升级失败 [英] mysql_upgrade - FATAL ERROR: Upgrade Failed

问题描述

我最近将我的MySQL服务器从5.1升级到了5.5，我正在尝试使用mysql_upgrade升级数据库，但我一直收到此错误:

I recently had my MySQL server upgraded from 5.1 to 5.5 and I'm trying to upgrade my databases using mysql_upgrade but I keep getting this error:

[root@ip-??-???-???-??? ~]# mysql_upgrade -uadmin -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed

我不知道为什么这将无法运行. MySQL Server正在运行.

I can't figure why this won't run. MySQL Server is running.

推荐答案

在OS X(通过MacPorts安装)上，从MySQL 5.5到5.6，我遇到了同样的问题.

I had the same issue going from MySQL 5.5 to 5.6 on OS X (installed via MacPorts).

似乎mysql_upgrade需要以用户root的身份运行，并且仅root，并且需要为该用户设置密码.具有管理特权的任何其他用户似乎都不起作用.

Seems that mysql_upgrade needs to be run as user root and only root and a password needs to be set up for the user. Any other user with administrative privileges does not seem work.

所以唯一有效的命令似乎是:mysql_upgrade -u root -p

So the only valid command seems to be: mysql_upgrade -u root -p

由 Chris_H在FreeBSD论坛上的初始解决方案.

这篇关于mysql_upgrade-致命错误:升级失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！