D:\mysql-5.7.39-winx64\bin>mysql_upgrade -uroot -p
Enter password: ********
Checking if update is needed.
Checking server version.
Error: Server version (5.7.35) does not match with the version of
the server (5.7.39) with which this program was built/distributed. You can
use --skip-version-check to skip this check.
D:\mysql-5.7.39-winx64\bin>mysql_upgrade -uroot -p --skip-version-check
Enter password: ********
Checking if update is needed.
Running queries to upgrade MySQL server.
mysql_upgrade: [ERROR] 1142: CREATE command denied to user 'root'@'localhost' for table 'processlist'
报错信息如上
我的操作是按照这个来得升级方法
授个权试试
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON *.* TO root@'localhost' identified by '你的密码';
评论
有用 1GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON *.* TO root@'localhost' identified by '密码';
评论 有用 1
