解決CentOS安裝mariadb 後 mysql 無法啟動

解決CentOS安裝mariadb 後 mysql 無法啟動

yum install mysql 顯示 mysql 安裝完成，但service mysql status, service mysql start 均提示失敗，資料庫也無法登陸。

[root@ansible flask_sqlalchemy]# service mysql status
Redirecting to /bin/systemctl status mysql.service
● mysql.service
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)
[root@ansible flask_sqlalchemy]# service mysql start
Redirecting to /bin/systemctl start mysql.service
Failed to start mysql.service: Unit mysql.service failed to load: No such file or directory.

[root@ansible flask_sqlalchemy]# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

解決方案：

# yum install mariadb-server -y

# systemctl start mariadb.service

# systemctl enable mariadb.service

# mysql

參考：http://www.centoscn.com/CentosBug/softbug/2016/0115/6660.html

資料庫可以登陸，但是service mysql 仍然提示上述錯誤，原因還需進一步分析。