老版本的MySQL服务卸载,当新版本成功安装后,容易导致服务无法正常启动,状况如下图:
[root@iZ2ze8so5iye7uy23id6ezZ mysql]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
此时需要在启动的时候添加如下参数:
[root@iZ2ze8so5iye7uy23id6ezZ mysql]# service mysqld start --skip-grant-tables
Starting mysqld: [ OK ]
服务启动成功!当时还没完,需要对当前MySQL库进行更新:
[root@iZ2ze8so5iye7uy23id6ezZ mysql]# mysql_upgrade
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
.........
至此,MySQL服务恢复正常