This article is going to teach you how to install MariaDB 10.7 on CentOS 7. MariaDB is a MySQL fork. To put it another way, it’s a better, drop-in substitute for MySQL. A drop-in replacement means that you may use the analog version of the MariaDB server to replace the regular MySQL server and benefit from all of MariaDB’s advancements without having to change your application code.
MariaDB is a fast, scalable, and reliable database. It has a larger number of storage engines than MySQL. MariaDB also comes with a slew of plugins and utilities that make it adaptable to a wide range of scenarios.
How to Install MariaDB 10.7 on CentOS 7
- Lets start by adding MariaDB YUM repository on CentOS 7. Note, If you’re using another MySQL-based database management system, you’ll need to uninstall it first before proceeding with this installation.
- Add MariaDB YUM repository
- Install MariaDB 10.7 on CentOS 7
- Secure MariaDB in CentOS 7
- Connect to MariaDB
Add MariaDB YUM repository
- Run the command below to add MariaDB YUM repository.
curl -LsS -O https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
sudo bash mariadb_repo_setup --mariadb-server-version=10.7Sample Output
# [info] Checking for script prerequisites. # [info] MariaDB Server version 10.7 is valid # [info] Repository file successfully written to /etc/yum.repos.d/mariadb.repo # [info] Adding trusted package signing keys... /etc/pki/rpm-gpg /home/kigz /home/kigz # [info] Successfully added trusted package signing keys # [info] Cleaning package cache... Loaded plugins: fastestmirror, langpacks Cleaning repos: base epel extras mariadb-main mariadb-maxscale mariadb-tools remi-php74 remi-safe updates Cleaning up list of fastest mirrors
Install MariaDB 10.7 on CentOS 7
- After you’ve added the MariaDB repository, we may now proceed with the installation of MariaDB 10.7 on CentOS 7
sudo yum install MariaDB-server MariaDB-client -ySample Output
# [info] Checking for script prerequisites. # [info] MariaDB Server version 10.7 is valid # [info] Repository file successfully written to /etc/yum.repos.d/mariadb.repo # [info] Adding trusted package signing keys... /etc/pki/rpm-gpg /home/kigz /home/kigz # [info] Successfully added trusted package signing keys # [info] Cleaning package cache... Loaded plugins: fastestmirror, langpacks Cleaning repos: base epel extras mariadb-main mariadb-maxscale mariadb-tools remi-php74 remi-safe updates Cleaning up list of fastest mirrors [kigz@localhost ~]$ yum install MariaDB-server MariaDB-client -y Loaded plugins: fastestmirror, langpacks You need to be root to perform this command. [kigz@localhost ~]$ sudo yum install MariaDB-server MariaDB-client -y [sudo] password for kigz: Loaded plugins: fastestmirror, langpacks Determining fastest mirrors epel/x86_64/metalink | 36 kB 00:00:00 * base: centos.mirror.liquidtelecom.com * epel: d2lzkl7pfhq30w.cloudfront.net * extras: centos.mirror.liquidtelecom.com * remi-php74: remirepo.reloumirrors.net * remi-safe: remirepo.reloumirrors.net * updates: centos.mirror.liquidtelecom.com base | 3.6 kB 00:00:00 epel | 4.7 kB 00:00:00 extras | 2.9 kB 00:00:00 mariadb-main | 3.4 kB 00:00:00 mariadb-maxscale | 2.5 kB 00:00:00 mariadb-tools | 2.9 kB 00:00:00 remi-php74 | 3.0 kB 00:00:00 remi-safe | 3.0 kB 00:00:00 updates | 2.9 kB 00:00:00 (1/13): epel/x86_64/group_gz | 96 kB 00:00:00 (2/13): base/7/x86_64/group_gz | 153 kB 00:00:01 (3/13): base/7/x86_64/primary_db | 6.1 MB 00:00:01 (4/13): extras/7/x86_64/primary_db | 243 kB 00:00:01 (5/13): epel/x86_64/updateinfo | 1.0 MB 00:00:03 (6/13): epel/x86_64/primary_db | 7.0 MB 00:00:04 (7/13): mariadb-main/updateinfo | 4.9 kB 00:00:02 (8/13): mariadb-tools/primary_db | 17 kB 00:00:01 (9/13): mariadb-maxscale/primary_db | 7.1 kB 00:00:02 (10/13): mariadb-main/primary_db | 55 kB 00:00:03 (11/13): updates/7/x86_64/primary_db | 13 MB 00:00:02 (12/13): remi-php74/primary_db | 254 kB 00:00:02 (13/13): remi-safe/primary_db | 2.1 MB 00:00:09 Resolving Dependencies --> Running transaction check ---> Package MariaDB-client.x86_64 0:10.7.3-1.el7.centos will be installed
- You can check details about the version you just installed using the command below.
rpm -qi MariaDB-server- Next, run the command below to start MariaDB
systemctl start mariadb- Then enable it using the following command.
systemctl enable mariadb- You can check its status using the command below.
systemctl status mariadbSample output
● mariadb.service - MariaDB 10.7.3 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Fri 2022-02-18 19:24:07 EAT; 2min 7s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 15591 (mariadbd)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─15591 /usr/sbin/mariadbd
Feb 18 19:24:07 localhost.localdomain mariadbd[15591]: 2022-02-18 19:24:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Feb 18 19:24:07 localhost.localdomain mariadbd[15591]: 2022-02-18 19:24:07 0 [Note] InnoDB: 10.7.3 started; log sequence number 413... id 14
Feb 18 19:24:07 localhost.localdomain mariadbd[15591]: 2022-02-18 19:24:07 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 18 19:24:07 localhost.localdomain mariadbd[15591]: 2022-02-18 19:24:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/my...r_pool
Feb 18 19:24:07 localhost.localdomain mariadbd[15591]: 2022-02-18 19:24:07 0 [Note] Server socket created on IP: '0.0.0.0'.
Feb 18 19:24:07 localhost.localdomain mariadbd[15591]: 2022-02-18 19:24:07 0 [Note] Server socket created on IP: '::'.
Feb 18 19:24:07 localhost.localdomain mariadbd[15591]: 2022-02-18 19:24:07 0 [Note] InnoDB: Buffer pool(s) load completed at 220218 19:24:07
Feb 18 19:24:07 localhost.localdomain mariadbd[15591]: 2022-02-18 19:24:07 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 18 19:24:07 localhost.localdomain mariadbd[15591]: Version: '10.7.3-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 ...Server
Feb 18 19:24:07 localhost.localdomain systemd[1]: Started MariaDB 10.7.3 database server.
Hint: Some lines were ellipsized, use -l to show in full.
Secure MariaDB on CentOS 7
- Run the command below to secure your MariaDB.
sudo mariadb-secure-installationSample output
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
haven't set the root password yet, you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password or using the unix_socket ensures that nobody
can log into the MariaDB root user without the proper authorisation.
You already have your root account protected, so you can safely answer 'n'.
Switch to unix_socket authentication [Y/n] y
Enabled successfully!
Reloading privilege tables..
... Success!
You already have your root account protected, so you can safely answer 'n'.
Change the root password? [Y/n] n
... skipping.
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!
Connect to MariaDB
- You can now use your root password to access MariaDB. Run the command below to do so
sudo mysql -u rootSample output
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 14 Server version: 10.7.3-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
- You are done installing MariaDB on CentOS 7, you can now create your databases.
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 14 Server version: 10.7.3-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> CREATE DATABASE itnixpro; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | itnixpro | | mysql | | performance_schema | | sys | +--------------------+ 5 rows in set (0.002 sec) MariaDB [(none)]>
- Congratulations you have reached the end of the article. You have learned how to Install MariaDB 10.7 on CentOS 7.
Other Tutorials
Install WordPress with LAMP Stack on Ubuntu 22.04
