{"id":7465,"date":"2018-05-28T14:31:35","date_gmt":"2018-05-28T06:31:35","guid":{"rendered":"http:\/\/rmohan.com\/?p=7465"},"modified":"2018-05-28T14:31:35","modified_gmt":"2018-05-28T06:31:35","slug":"installing-mariadb-on-centos-linux-7-5","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=7465","title":{"rendered":"Installing MariaDB on CentOS Linux 7.5"},"content":{"rendered":"

MariaDB is an open source relational database management system that is backwards compatible and replaces MySQL with binary.\u00a0It was developed by some of MySQL’s original developers and many in the community.\u00a0With\u00a0the release\u00a0of\u00a0<\/span>CentOS<\/span><\/a>\u00a07, MySQL was replaced by MariaDB as the default database system.<\/span><\/p>\n

If for any reason you need to install MySQL, check out how to install MySQL on the CentOS 7 tutorial.\u00a0If your application does not have any specific requirements, you should stick with MariaDB, the default database system in CentOS 7.<\/span><\/p>\n

In this tutorial, we will show you how to install the latest version of MariaDB on CentOS 7 using the official MariaDB repository.\u00a0The MariaDB server version provided in the default CentOS repository is version 5.5 and is not the latest stable version of MariaDB.<\/span><\/p>\n

Install MariaDB<\/span><\/strong><\/p>\n

At the time of this writing, the latest version of MariaDB is version 10.3.<\/span><\/p>\n

Create a repository file called MariaDB.repo and add the following:<\/span><\/p>\n

\/etc\/yum.repos.d\/MariaDB.repo<\/span><\/p>\n

# MariaDB 10.3 CentOS repository list – created 2018-05-27 07:02 UTC\u00a0<\/span>
\n# http:\/\/downloads.mariadb.org\/mariadb\/repositories\/\u00a0<\/span>
\n[mariadb]\u00a0<\/span>
\nname = MariaDB\u00a0<\/span>
\nbaseurl = http:\/\/yum.mariadb.org\/ 10.3\/centos7-amd64\u00a0<\/span>
\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\u00a0<\/span>
\ngpgcheck=1<\/span><\/p>\n

If you need to install any other version of MariaDB, generate a repository for your desired version of MariaDB on this page (https:\/\/downloads.mariadb.org\/mariadb\/repositories\/).<\/span><\/p>\n

We will use yum to install the MariaDB server and client packages, just like other CentOS packages, by typing the following command:<\/span><\/p>\n

Sudo yum install MariaDB-server MariaDB-client<\/span><\/p>\n

Yum may prompt you to import the MariaDB GPG key:<\/span><\/p>\n

Retrieving key from https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\u00a0<\/span>
\nImporting GPG key 0x1BB943DB:\u00a0<\/span>
\nUserid : “MariaDB Package Signing Key <package-signing-key@mariadb.org>”\u00a0<\/span>
\nFingerprint: 1993 69e5 404b d5fc 7d2f e43b cbcb 082a 1bb9 43db\u00a0<\/span>
\nFrom : https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB<\/span><\/p>\n

Type y and press Enter.<\/span><\/p>\n

After the installation is complete, enable and start the MariaDB service:<\/span><\/strong><\/p>\n

Sudo systemctl enable mariadb\u00a0<\/span>
\nsudo systemctl start mariadb<\/span><\/p>\n

Once the MySQL service starts, we can check its status by entering the following:<\/span><\/p>\n

Sudo systemctl status mariadb<\/span><\/p>\n

Sample output:<\/span><\/p>\n

? mariadb.service – MariaDB 10.3.7 database server\u00a0<\/span>
\n\u00a0 Loaded: loaded (\/usr\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: disabled)\u00a0<\/span>
\n\u00a0 Drop-In: \/etc\/systemd\/system\/mariadb.service. d\u00a0<\/span>
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ??migrated-from-my.cnf-settings.conf\u00a0<\/span>
\n\u00a0 Active: inactive (dead)\u00a0<\/span>
\n\u00a0 \u00a0 Docs: man:mysqld(8)\u00a0<\/span>
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 https:\/\/mariadb.com\/kb\/en\/library\/systemd\/<\/span><\/p>\n

And print the MariaDB server version, which contains:<\/span><\/p>\n

Mysql -V<\/span><\/p>\n

Mysql Ver 15.1 Distrib 10.3.7-MariaDB, for Linux (x86_64) using readline 5.1<\/span><\/p>\n

Protecting MariaDB security<\/span><\/strong><\/p>\n

Run the mysql_secure_installation command to improve MariaDB installation security:<\/span><\/p>\n

Sudo mysql_secure_installation<\/span><\/p>\n

The script prompts you to set the root password, remove the anonymous user, restrict the root user’s access to the local computer, and delete the test database.\u00a0All steps are detailed and it is recommended to answer “yes” (yes) to all questions.<\/span><\/p>\n

Connect to MariaDB from the command line<\/span><\/p>\n

To connect to the MariaDB server through the terminal, we will use the MariaDB client.<\/span><\/p>\n

You can log in to the MariaDB server as root by typing:<\/span><\/p>\n

Mysql -u root -p<\/span><\/p>\n

You will be prompted to enter the previously set root password when running the mysql_secure_installation script.<\/span><\/p>\n

Once you enter the password, you will see the MariaDB shell as follows:<\/span><\/p>\n

Welcome to the MariaDB monitor. Commands end with ; or \\g.\u00a0<\/span>
\nYour MariaDB connection id is 8\u00a0<\/span>
\nServer version: 10.3.7-MariaDB MariaDB Server<\/span><\/p>\n

Copyright (c) 2000, 2018,\u00a0<\/span>Oracle<\/span><\/a>\u00a0, MariaDB Corporation Ab and others.<\/span><\/p>\n

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

MariaDB is an open source relational database management system that is backwards compatible and replaces MySQL with binary. It was developed by some of MySQL’s original developers and many in the community. With the release of CentOS 7, MySQL was replaced by MariaDB as the default database system.<\/p>\n

If for any reason you need to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7465"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7465"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7465\/revisions"}],"predecessor-version":[{"id":7466,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7465\/revisions\/7466"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}