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.
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.
# nano /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
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 mariadb # systemctl start mariadb
Step 3 – Secure MariaDB Install
– Once install is complete, Run Command mysql_secure_installation
The script will prompt you to determine which actions to perform.
More customisation official documents link
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!