Workaround for CentOS7 unable to start MySQL

MARIADB database management System is a branch of MySQL, mainly by the open source community in the maintenance, the use of GPL license. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of shutting MySQL out of the source, so the community uses a branching approach to avoid this risk. [3]

MARIADB is designed to be fully compatible with MySQL, including APIs and command lines, making it easy to be a replacement for MySQL. In the storage engine, version 10.0.9 uses xtradb (named aria) instead of MySQL's InnoDB

# yum install mysql -y# mysqlERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (111)

Try to start the MySQL service, still no

# systemctl start mysqlFailed to issue method call: Unit mysql.service failed to load: No such file or directory.# systemctl start mysql.serviceFailed to issue method call: Unit mysql.service failed to load: No such file or directory# systemctl enable mysql.serviceFailed to issue method call: Access denied

Here are the correct steps

# yum Install mariadb-server-y# Systemctl Start Mariadb.service# Systemctl Enable Mariadb.service# MysqlwelcomeToThe MariaDB Monitor. CommandsEnd With ; or \g.your MariaDB connection ID is 10Server version: 5.5. 44-mariadb MariaDB servercopyright (c) c9>2000, Oracle, MariaDB Corporation Ab and others. Type ' help; ' or ' \h ' for help . Type ' \c ' to clear the current   input statement. MariaDB [(None)]>              

Get!

How to set the MySQL root password

# mysql_secure_installation

Workaround for CentOS7 unable to start MySQL