Configure MariaDB for centos7
Later than centos 7, I started to use MariaDB. Next I will share with you the configuration of MariaDB and some possible problems. I. What is MariaDB?
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 Oracle has the potential risk of shutting down the source of MySQL after purchasing MySQL. Therefore, the community uses the branch method to avoid this risk. Over the past year, large Internet users and Linux publishers have abandoned MySQL and switched to the MariaDB camp. MariaDB is currently the most popular MySQL database derivative version, and is also considered a substitute for open-source database MySQL. According to the above introduction, we can simply use mysql to change its name to MariaDB. Some function operations remain unchanged. Ii. Install and start MariaDB Currently, the new centos7 host comes with the MariaDB installation command yum-yinstallmariadb mariadb-server to start MariaDBsystemctl start mariadb to set systemctl enable mariadb to enable mysql-u root password 'root'. 3. Authorization remote Access 1. log on to mysql 2. Check which databases exist. 3. Access the mysql database to change all tables of all databases (*. *) all permissions (all privileges) are granted to the root user who accesses through any ip address (%), the password is 123456, and finally refresh (flush privileges) 4. Firewall Configuration Most of the firewalls in centos7 are firewall. add a port to firewall to allow access to port 3306: firewall-cmd -- permanent -- add-port = 3306/tcp1, firewall-cmd: is a tool provided by Linux to operate firewall; 2. -- permanent: indicates to be set to persistent; 3. -- add-port: indicates the added port; then restart the firewall Service systemctl restart firewall. If it still does not work, disable firewall and execute systemctl stop firewall 5 and Navicat. Great success ~
