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 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
Please change the version (red highlighted) in the below setting as per the 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.4 in your system. This will also install other dependencies automatically.
#### For CentOS/RHEL 7/6 sudo yum install MariaDB-server MariaDB-client #### For Fedora sudo dnf install MariaDB-server MariaDB-client
After installing MariaDB in your system start it’s service using the following command.
## CentOS/RHEL 7 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 the 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.
Please update
## CentOS/RHEL 7
sudo systemctl start mysql.service
## CentOS/Redhat 6
sudo service mysql start
to
systemctl start mariadb
or
service mariadb start
This will come in handy for anyone who has installed MariaDB 10.4.8
Do not add the yum repository yourself. Instead leave it up by the MariaDB installer:
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
sudo yum install MariaDB-server MariaDB-client
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