appnode切换mysql版本后部署提示:服务器内部错误:创建用户失败!

appnode面板因需要5.5切换到5.6后点击部署,提示:服务器内部错误:创建用户失败!

鼠标移到提示右上角表符号现实类似:

ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected **, found**. Created with MySQL *****, now running *****. Please use mysql_upgrade to fix this error.

出现这个错误主要是因为升级了数据库没有使用过,登录ssh终端使用如下命令即可:

mysql_upgrade -u root -p

输入mysql root密码,输出类似:

[root@VM-0-10-centos ~]# mysql_upgrade -u root -p
Enter password: 
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
OK

再次部署无错误出现。

 

0

Related Posts

Comments

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注