MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.
MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server.
In this tutorial, we will explain how to install the latest version of MariaDB on a CentOS 7 / RHEL 7 server.
Step 1: Add MariaDB Yum Repository
– Create a new repo file /etc/yum.repos.d/mariadb.repo and add the below code changing the base url according to the operating system version and architecture.
# vi /etc/yum.repos.d/mariadb.repo [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.3/centos73-amd64/ gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
Step 2 – Install MariaDB Server
– Let’s use the following command to install MariaDB 10.3 .
# yum install MariaDB-server MariaDB-client
– Once the installation is complete, we’ll enable and start the daemon with the following commands:
# systemctl enable mysql.service # systemctl start mysql.service
Step 3 – Secure MariaDB Install
– MariaDB includes a security script “mysql_secure_installation” to change some of the less secure default options for things like remote root logins and sample users. To do this you can read our previous article Securing MySQL server / Mariadb with mysql_secure_installation from command line guide.
Step 4 – Working with MariaDB
– Once the configuration is complete, connect to MariaDB server using the following command.
# mysql -u root -p Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 16 Server version: 10.3.2-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
– Let’s create a new database
## CREATE DATABASE MariaDB [(none)]> CREATE DATABASE Test_db;
– Create a database user account
## CREATE USER ACCOUNT MariaDB [(none)]> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'Password';
– Grant permissions on the database “Test_db” for the new user “dbuser”, the bellow command allows the user “dbuser” to read, edit, execute and perform all tasks across the database “Test_db”.
## GRANT PERMISSIONS ON DATABASE MariaDB [(none)]> GRANT ALL ON Test_db.* TO 'dbuser'@'localhost';
– Once you have grant the permissions that you want to set up for your new users, make sure to reload all the privileges using the following command:
## RELOAD PRIVILEGES MariaDB [(none)]> FLUSH PRIVILEGES;
We hope this tutorial was enough Helpful. If you need more information, or have any questions, just comment below and we will be glad to assist you!
PS. If you like this post please share it with your friends on the social networks using the buttons below.Thanks.