![\"\"](\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/02\/install-mariadb-centos.jpg\")
<\/p>\n<\/p>\n
On a fresh Linux installation, you may have MySQL already installed on your system. While that might be enough for most users, sometimes the newest version of the query language is necessary for some software to work. This tutorial will show you how to install MariaDB as a drop-in replacement for MySQL for all versions of CentOS, and all versions of MariaDB.<\/p>\n
When Oracle took over the development of MySQL in 2008, it switched to a slower release cycle, and the development became a lot more opaque. One of the lead developers of MySQL decided to fork the project, and MariaDB is the result. The idea was to continue the development of the database in a community-driven manner and to provide a \u201cdrop-in\u201d replacement for MySQL.<\/p>\n
It simply means that you don\u2019t have to change any other configuration on systems that rely on MySQL. Once you install and activate MariaDB, all other programs that used to work with MySQL will now work seamlessly on MariaDB.<\/p>\n
In other words, if you\u2019re running WordPress, you don\u2019t need to change any scripts or your wp-config.php file when you migrate to MariaDB.<\/p>\n
Here\u2019s how to install MariaDB on a CentOS VPS<\/a>.<\/p>\n The URL from which we get the MariaDB packages depends on the OS version, as well as the version of MariaDB we want to install. To get your OS version, type the following command:<\/p>\n cat \/etc\/redhat-release<\/p>\n This will tell you which version of CentOS you\u2019re running. In this example, we\u2019re going to use CentOS version 6.10. As of this writing, the stable version of MariaDB is sitting on 10.3, so that\u2019s what we\u2019re going to install right now.<\/p>\n The official website makes it easy to configure the repository script. Visit the interactive tool<\/a> and choose your OS, as well as the OS version and the MariaDB package that you want to install, based on what you decided in Step 1. Here\u2019s a screenshot of our configuration:<\/p>\n Once you make these selections, it\u2019ll display a snippet of text on the bottom of the page. Like this:<\/p>\n The important part is the \u201cbaseurl\u201d parameter as shown above. This is what varies between various installations.<\/p>\n The next step is to create a file in the following directory:<\/p>\n \/etc\/yum.repos.d\/<\/p>\n We\u2019re going to name it \u201cMariaDB.repo\u201d for easy reference later on. Use a text editor like nano or vi to paste the code you got in Step 2 into the file like this:<\/p>\n Save your changes, and you\u2019re done with adding the repository file. Make sure to have yum recognize the changes by running this command:<\/p>\n sudo yum update<\/p>\n Now that the repo is configured, we can install MariaDB by typing in the following:<\/p>\n sudo yum install MariaDB-server MariaDB-client<\/p>\n Note that if you had a previous MariaDB repo, or accidentally used the wrong one, you would have gotten a message saying:<\/p>\n “No package MariaDB-server available”<\/p>\n Unfortunately, the configurations are saved, so before you run the \u201cyum\u201d command with a new repo, you must remember to flush it with the command:<\/p>\n yum clean metadata<\/p>\n But if everything goes well, you should now be able to install the MariaDB packages like this:<\/p>\n Note how it says \u201creplacing mysql\u201d. This means that the new database system will response to the \u201cmysql\u201d command from now on.<\/p>\n If this is the first time you\u2019re installing MariaDB, you\u2019ll also be asked to confirm the import of the GPG key as shown here:<\/p>\n After the installation is complete, you will have MariaDB on your system!<\/p>\n MariaDB is such a perfect replacement for mysql, that it can be difficult to tell whether the current software running is MySQL or MariaDB! However, if you type the following command:<\/p>\n mysql -V<\/p>\n It will give you the version information, as well as the database system that\u2019s driving it:<\/p>\n If you followed the tutorial step by step, then congratulations, you\u2019ve replaced MySQL with MariaDB!<\/p>\n Of course, you don\u2019t need to install MariaDB yourself if you have a CentOS VPS<\/a> hosted with us, in which case our expert sysadmins will install MariaDB for you. They are available 24\u00d77 and can help you with any questions or issues that you may have.<\/p>\n PS. If you enjoyed reading this blog post on how to install MariaDB on CentOS, feel free to share it on social networks using the share shortcuts.<\/p>\nStep 1: Get the MariaDB and CentOS Version<\/h2>\n
Step 2: Get the Script for the MariaDB Repository<\/h2>\n
![\"Generate](\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/02\/Generate-Repository.jpg\")
<\/p>\n![\"Entry](\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/02\/Entry-for-Yum-Repo.jpg\")
<\/p>\nStep 3: Create the Repo File in CentOS<\/h2>\n
![\"Create](\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/02\/Create-Yum-Repo-File.jpg\")
<\/p>\nStep 4: Installing MariaDB<\/h2>\n
![\"Replace](\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/02\/Replace-MySQL-1.jpg\")
<\/p>\n![\"Import](\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/02\/Import-GPG-Key.jpg\")
<\/p>\nStep 5: Verifying the Installation<\/h2>\n
![\"Check](\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/02\/Check-MariaDB-Version.jpg\")
<\/p>\n