MARIADB installation in CentOS 7

MySQL is considered the most popular database management system, but advanced users know that recently the development of this tool split into two parts, and as a result, it led to the emergence of a new wealthy solution called MariaDB. Now, many are preferred by this DBMS for various reasons, on which we will not stop today, since our main goal is to demonstrate how this component is installed in CentOS 7 on the example of step-by-step guide.

Install MariaDB in CentOS 7

If the installation of the MARIADB database management system was possible through standard OS repositories, then this article was as short as possible. However, the developers have gone a bit the other way that causes some new problems and difficulties. The method consists in the fact that the repository file is hand-assembled by the user, and then going on a package loading. We will talk about it in the second step, and now let's deal with the preparatory work.

Step 1: Preliminary actions

On the official site will have to choose the CENTOS assembly, and some users do not have such information, therefore the first task that should be performed is to determine the current version of the OS. On our site there is a separate article that allows you to cope with the task. Read it by clicking on the link below, and implement one of the above methods.

Read more: Definition of the version of CENTOS

Now let's go to the site itself. As mentioned earlier, it will be used to build your configuration file to implement the package download. To get the right code, you will need to make such actions:

Go to the official site of mariadb

1. Go to the above link and select "CENTOS" in the list.



2. The second column will appear. Here, determine the release by clicking on the corresponding string.



3. It remains only to specify the version that we learned earlier.



4. You get a table with the code and installation instructions, but novice users can all be clear.

If you yourself have understood the principle of the installation on the table, proceed immediately to the configuration, skipping the second step, and inexperienced users to we advise you to pay attention to the following guidelines.

Step 2: File Assembling and Installing MariaDB

As you already know, you must first create a file itself by placing it in a special location in the local storage. Then you will only enter the command and confirm all your actions. More detailed this procedure looks like this:

1. Run the console with a convenient method, for example, through the application menu.



2. Here we recommend installing a convenient text editor so that there are no problems with saving the file. Enter Sudo Yum Install Nano and click on the ENTER key.



3. This action is performed on behalf of the superuser, so you have to confirm the account by writing a password. Note that the characters entered in this way are not displayed in the row.



4. Agree with installation or if Nano has already been added to the system, go to the next action.



5. Enter sudo nano /etc/yum.repos.d/mariadb.repo to create a new repository file in the required location.



6. Immediately a text editor will open in which you can make sure that the file really was created just.



7. Insert the contents that were received on the official website of MariaDB.



8. Save the changes using the hot key Ctrl + O.



9. When a new line appears, you do not need to change the location or name, just click on ENTER.



10. After that, leave the text editor via Ctrl + X.



11. Insert the following command sudo yum install mariadb-server mariadb-client and confirm it.



12. Expect until all archives are transferred to the computer.



13. A string will appear, notifying the package installation. Confirm the action by selecting the Y version.



14. Next will be created a public key used to access the database management system. Check out the information and wait for the end of the installation.

On this installation ended. It remains only to set the initial configuration to make sure that the tool function is normal. This operation will be devoted to our final stage.

Step 3: Initial Configuration

This stage is not aimed at providing guidance on the complete setting of the DBMS, since all this is subjective and depends on the additional components used. Now we only offer to activate the service and provide standard security rules in parallel by installing the root password.

1. In the "Terminal", sudo SystemCTL Start Mariadb in order to run the MariaDB service.



2. Agree with this operation, specifying the superuser password.



3. If you received information about the absence of a file, then the current version of the DBMS was installed on top of the past. You will have to insert the command mv /etc/systemd/system/mariadb.service{bak}, and then repeat the launch.



4. Use sudo mysql_upgrade to update the tables if installed the tool over the old version.



5. It remains only to set the standard rules to secure the system from hacking. This uses sudo mysql_secure_installation.



6. Follow the instructions that appear to create a new password and basic protection rules.

We offer to learn about all the other configuration points of MariaDB in the official documentation. Developers provide many useful commands and codes that will help create an optimal database management system, taking care of its safety.

Go to official MARIADB documentation

Now you know what to install MariaDB is harder than the usual programs, but still quite feasible even without additional knowledge and skills. It remains only to follow the instructions given and examine the documentation to get used in this DBMS.

See also:

Installing phpMyadmin in CentOS 7

Installation PHP 7 in CentOS 7