CENTOS7 Yum Installation mariadb

Starting with the latest version of CENTOS7, the default is mariadb instead of mysql!

Using the system's own repos installation is simple:

Yum Install mariadb Mariadb-server

Systemctl start mariadb ==> start mariadb

Systemctl enable mariadb ==> boot from

Firewall-cmd--permanent--add-port=3306/tcp ==> Open port, allows remote access

Systemctl Restart firewalld==> reboot firewall

Mysql_secure_installation ==> Setting the root password and other related

mysql-uroot-p Password ==> Test login!

Authorize root remote any machine can login

Use MySQL;

Update MySQL set host= '% ' where user= ' root ' and host= ' localhost ';

Flush privileges;

Or

Grant all privileges on * * to ' [email protected]% ' identified by ' password ' with GRANT option;

Flush privileges;

This article is from the "Blue Sky" blog, make sure to keep this source http://shurk.blog.51cto.com/1134443/1745524

CENTOS7 Yum Installation mariadb