Forked from\u00a0MySQL, MariaDB<\/strong>\u00a0has been known to be a drop-in replacement that brings enhancements and\u00a0performance optimizations over MySQL<\/strong>. This tutorial will show you how to\u00a0install MariaDB onto CentOS 7<\/strong>\u00a0in two different ways.<\/p>\n

Step 1: Download\/install MariaDB<\/strong><\/h2>\n

Install from repository<\/strong><\/h3>\n

MariaDB<\/strong>\u00a0is shipped in the\u00a0CentOS repo as of CentOS 7<\/strong>. Anything lower will need require you to add the additional repository to your server.\u00a0Run the following command on your server:<\/strong><\/p>\n

yum update -y\r\nyum install mariadb-server\r\n<\/code><\/pre>\n
You may also need to finish the installation by running:<\/p>\n
\/usr\/bin\/mysql_secure_installation\r\n<\/code><\/pre>\n
This will\u00a0install MariaDB<\/strong>\u00a0and walk you through the process of setting up your root password.<\/p>\n
Manual install from MariaDB mirror (latest version)<\/strong><\/h3>\n
This\u00a0should be straightforward<\/strong>. You will need to create a file in\u00a0\/etc\/yum.repos.d\/<\/code>and add the following:<\/p>\n
[mariadb] \r\nname = MariaDB \r\nbaseurl = http:\/\/yum.mariadb.org\/10.0\/centos7-amd64 \r\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB \r\ngpgcheck=1\r\n<\/code><\/pre>\n
Once the file is\u00a0created<\/strong>, run the following commands:<\/p>\n
yum update -y\r\nyum install MariaDB-server MariaDB-client\r\n<\/code><\/pre>\n
You can then\u00a0finish the installation<\/strong>\u00a0by running:<\/p>\n
\/usr\/bin\/mysql_secure_installation\r\n<\/code><\/pre>\n
If everything was successful<\/strong>, proceed to the next step.<\/p>\n
Step 2: Verify that MariaDB is operational<\/strong><\/h2>\n
Depending on if you are using the default AKLWEB Host image of\u00a0CentOS 7<\/strong>\u00a0or if you are using a\u00a0Custom ISO<\/strong>, you may need to manually\u00a0start MariaDB<\/strong>\u00a0and enable it to start on boot of the server. To do so, run:<\/p>\n
systemctl start mariadb.service\r\nsystemctl enable mariadb.service\r\n<\/code><\/pre>\n
You can check to see if everything is running by executing the following command:<\/strong><\/p>\n
systemctl is-active mariadb.service\r\n<\/code><\/pre>\n
After installation, run\u00a0mysql -u root -p<\/code>. Enter your password when prompted. You will see output similar to the following:<\/p>\n
Welcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is XXXX\r\nServer version: 5.5.X\r\nCopyright (c) 2000, 2014, Oracle, Monty Program Ab and others.\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\nMariaDB [(none)]> \r\n<\/code><\/pre>\n
Congratulations, you have successfully installed MariaDB on CentOS 7<\/strong>. If you get an error regarding connection, please make sure that\u00a0MariaDB<\/strong>\u00a0is running by repeating the beginning of Step 2. Enjoy!<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","manualknowledgebasecat":[110,231,242],"manual_kb_tag":[341],"_links":{"self":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb\/2544"}],"collection":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/comments?post=2544"}],"version-history":[{"count":1,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb\/2544\/revisions"}],"predecessor-version":[{"id":2545,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb\/2544\/revisions\/2545"}],"wp:attachment":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/media?parent=2544"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manualknowledgebasecat?post=2544"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb_tag?post=2544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}