MariaDB 10.4 stable version has been released>. It is an enhanced, drop-in replacement for MySQL. MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. Use below links to read features comparison between MariaDB and MySQL. This article will help you to install MariaDB 10.4 in CentOS, RHEL 7/6 and Fedora Fedora 30/29/28/27 systems using yum.
Step 1 – Add MariaDB Yum Repository
First add MariaDB yum repository in our system. Create a new repo file /etc/yum.repos.d/mariadb.repo in your system and add below code as per your operating system and architecture.
For CentOS/RHEL – 7
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.4/rhel7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
For CentOS/RHEL – 6
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.4/rhel6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
For Fedora – 30/29/28/27/26
Please change version (red highlighted) in below setting as per version of Fedora you used. Click here To view all available repositories.
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.4/fedora30 -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 in your system. This will also install other dependencies automatically.
sudo yum install MariaDB-server MariaDB-client
After installing MariaDB in your system start it’s service using the following command.
## CentOS/Redhat 7 & Fedora sudo systemctl start mysql.service ## CentOS/Redhat 6 sudo service mysql start
Step 3 – Secure MariaDB Install
You also need to secure your MariaDB installation using passwords and do some other changes. To do this run secure installation script from command line.
sudo /usr/bin/mysql_secure_installation
The secure installation script will ask for user input as some points, follow the installation as per below output showing, All user inputs are highlighted with red color.
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
Remove anonymous users? [Y/n] y
... Success!
Disallow root login remotely? [Y/n] y
... Success!
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
Thanks for using MariaDB!
Step 4 – Working with MariaDB
After installing and completing the configuration, connect to a MariaDB server using the following command.
sudo mysql -u root -p
Also try to create a new database, user and assign privileges to a database.
1 2 3 4 5 6 7 8 9 10 11 | ## CREATE DATABASE MariaDB [(none)]> CREATE DATABASE mydb; ## CREATE USER ACCOUNT MariaDB [(none)]> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'secret'; ## GRANT PERMISSIONS ON DATABASE MariaDB [(none)]> GRANT ALL ON mydb.* TO 'dbuser'@'localhost'; ## RELOAD PRIVILEGES MariaDB [(none)]> FLUSH PRIVILEGES; |
You may also required install phpMyAdmin to manage MariaDB using web interface, which provides easy way to work.
Thank you Rahull, worked went perfectly.
I also installed phpmyadmin, following your other tutorial. https://tecadmin.net/intstall-phpmyadmin-on-centos/
Thank you for sharing your knowledge with the community.
I followed these directions. YUM is insisting on trying to install mariaDB 10.1 even though I specified 10.3 like you said…
do you have update for centos7