Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to install and securely configure MariaDB on CentOS7" related knowledge, editor through the actual case to show you the process of operation, the method of operation is simple and fast, practical, I hope that this "how to install and securely configure MariaDB on CentOS7" article can help you solve the problem.

Step 1: add a mariadb yum repository

1. First, add the yum configuration file mariadb.repo file of mariadb to rhel/centos and fedora operating systems.

# vi / etc/yum.repos.d/mariadb.repo

Depending on your operating system version, select the appropriate content below to add to the end of the file.

Install in centos 7

[mariadb] name = mariadbbaseurl = http://yum.mariadb.org/10.1/centos7-amd64gpgkey=https://yum.mariadb.org/rpm-gpg-key-mariadbgpgcheck=1

Install in rhel 7

[mariadb] name = mariadbbaseurl = http://yum.mariadb.org/10.1/rhel7-amd64gpgkey=https://yum.mariadb.org/rpm-gpg-key-mariadbgpgcheck=1

Step 2: install mariadb in centos 7

2. When the mariadb warehouse address is added, you can easily install mariadb with the following command.

# yum install mariadb-server mariadb-client-y

3. After the mariadb package is installed, start the database service daemon immediately, and you can use the following operation settings to start the service automatically after the operating system restarts.

# systemctl start mariadb# systemctl enable mariadb# systemctl status mariadb

Step 3: security configuration of mariadb in centos 7

4. Now you can configure the security by setting the root account password for mariadb, disabling root remote login, deleting the test database and the test account, and finally reloading the permissions using the following command.

# mysql_secure_installation

5. After configuring the security configuration of the database, you may want to check the features of mariadb, such as version number, default parameter list, and login through the mariadb command line. As follows:

# mysql-v# mysqld-- print-defaults# mysql-u root-p on "how to install and securely configure MariaDB on CentOS7" ends here. Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.