Shulou(Shulou.com)06/01 Report--

This article mainly introduces "how to install and securely configure MariaDB on CentOS7.37". In daily operation, I believe many people have doubts about how to install and securely configure MariaDB on CentOS7.37. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how to install and securely configure MariaDB on CentOS7.37". Next, please follow the editor to study!

MariaDB is a free and open source branch of MySQL database, which has the same design idea as MySQL, and will still be free and open source in the future.

In this blog post, I will show you how to install MariaDB 10.1 stable release on the most widely used RHEL/CentOS and Fedora distributions.

What we know so far is that the Red Hat Enterprise Linux/CentOS 7. 0 distribution has switched the default database from MySQL to MariaDB.

It is important to note in this article that we assume that you can work with a root account on the server, or you can run any command using the sudo command.

* * step: add 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 = MariaDB baseurl = http://yum.mariadb.org/10.1/centos7-amd64 gpgkey= https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

Install in RHEL 7

[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.1/rhel7-amd64 gpgkey= https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

Add MariaDB YUM Warehouse

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

Install MariaDB in CentOS 7

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

Start the MariaDB service in CentOS 7

Step 3: security configuration of MariaDB in CentOS 7

4. Now you can configure the security by setting the root account password of MariaDB, disabling root remote login, deleting the test database and the test account. * you need to use the following command to reload permissions.

# mysql_secure_installation

MySQL Security configuration in CentOS 7

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

Check MySQL version information

Step 4: learn MariaDB Management

If you are just learning to use MySQL/MariaDB, you can learn through the following guidelines:

Novice Learning MySQL / MariaDB (1)

Novice Learning MySQL / MariaDB (2)

Basic Management commands of MySQL Database (3)

20 MySQL Management Command Mysqladmin (4)

Also check out the documentation below to learn how to optimize your MySQL/MariaDB service and use tools to monitor database activity.

15 MySQL/MariaDB tuning techniques

4 tools for monitoring MySQL/MariaDB database

At this point, the study on "how to install and securely configure MariaDB on CentOS7.37" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.