MySQL无法启动

今天遇到一个问题，装在CentOS上的MySQL数据库无法启动。

[root@li853-95 ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

[root@li853-95 mysql]# mysql /stop
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[root@li853-95 mysql]# mysql stop/waiting
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

[root@li853-95 mysql]# ps ax | grep mysql
14130 pts/1    S+     0:00 grep --color=auto mysql

后台也没有mysql进程存在。通过下面的命令查看MySQL版本：

[root@li853-95 /]# mysql -V
mysql  Ver 15.1 Distrib 5.5.50-MariaDB, for Linux (x86_64) using readline 5.1

原来MySQL已经升级到MariaDB。所以启动命令变为：

[root@li853-95 /]# systemctl start mariadb.service

[root@li853-95 /]# ps ax | grep mysql
15413 ?        Ss     0:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
15572 ?        Sl     0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
15980 pts/1    S+     0:00 grep --color=auto mysql
[root@li853-95 /]# 

MySQL server终于启动成功。下一步要做的就是将它加到自动启动项。