The MariaDB database management system is a branch of MySQL. it is mainly maintained by the open-source community and licensed by GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of closing the source of MySQL. Therefore, the community uses the branch method to avoid this risk. [3] MariaDB aims to be fully compatible with MySQL, including APIs and command lines, so that it can easily become a substitute for MySQL. For the storage engine, XtraDB (named"
The MariaDB database management system is a branch of MySQL. it is mainly maintained by the open-source community and licensed by GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of closing the source of MySQL. Therefore, the community uses the branch method to avoid this risk. [3]
MariaDB is designed to be fully compatible with MySQL, including APIs and command lines, so that it can easily become a substitute for MySQL. In terms of storage engine, XtraDB (named Aria) is used to replace InnoDB of MySQL in version 10.0.9.
# 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.
# 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
The following describes the correct steps.
# yum install mariadb-server -y# systemctl start mariadb.service# systemctl enable mariadb.service# mysqlWelcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 10Server version: 5.5.44-MariaDB MariaDB ServerCopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]>
Done!
How to set the mysql root password
# mysql_secure_installation