CENTOS7 installation configuration MySQL

Centos7 default comes with the MARIADB database, it is a branch of MySQL, mainly by the open source community in the maintenance, the use of GPL licensing MARIADB is fully compatible with MySQL, including the API and command line, so that it can easily become a substitute for MySQL.

1. Let's start by looking at whether we've installed MySQL (using any of the following commands)

(1). Yum List installed mysql*

(2). Rpm-qa | grep mysql*

2. Choose to install MySQL (MARIADB) if not installed

Yum Install mysql*

3. After successful installation, you can use the following command to set the status of the MySQL database

(1). Start mariadb or MySQL

Systemctl start Mariadb.service or Systemctl start Mysqld.service

(2). Close mariadb or MySQL

Systemctl Stop Mariadb.service or systemctl stop Mysqld.service

(3). Restart mariadb or MySQL

Systemctl Restart Mariadb.service or systemctl restart Mysqld.service

(4). Set MARIADB or MySQL boot

Systemctl enable Mariadb.service or Systemctl enable Mysqld.service

CENTOS7 installation configuration MySQL