In this article you will learn how to install MariaDB MySQL Server and MariaDB Client on RHEL 7 / CentOS 7. MariaDB MySQL Server is an open source database server application like Relational Database Management System (RDBMS) to create, update, delete and for other database related tasks. This is a database server like the MySQL database, and even the development of the MariaDB MySQL server application is only created by the MySQL team. The developers of MariaDB are MariaDB Corporation Ab and MariaDB Foundation first published the application on the year 2009 under GNU General Public License and promised to keep the application open source forever. MariaDB MySQL Server is a cross-platform application in the programming language C & C ++, which is available for almost all common operating systems such as Linux, Microsoft Windows, OS X, Solaris and FreeBSD.etc.
More information about MariaDB MySQL Server can be found on the official website HERE!
Perform the following steps to install MariaDB MySQL Server and MariaDB Client on RHEL 7 / CentOS 7:
Before we start installing MariaDB Mysql Server and MariaDB Client, we update the packages and repositories of CentOS 7 / RHEL 7 with the following command.
[[email protected] ~]# yum -y update # Update Packages & Repositories
Now you can install MariaDB MySQL Server and the MariaDB client. We can install both packages with the yum repository. For installation information, see the following command.
[[email protected] ~]# yum -y install mariadb-server mariadb # Install MariaDB MySQL Server & MariaDB Client Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile * base: centos.mirror.net.in * extras: ftp.iitm.ac.in * updates: ftp.iitm.ac.in Resolving Dependencies --> Running transaction check ---> Package mariadb.x86_64 1:5.5.52-1.el7 will be installed --> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.52-1.el7 for package: 1:mariadb-5.5.52-1.el7.x86_64 ---> Package mariadb-server.x86_64 1:5.5.52-1.el7 will be installed --> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.52-1.el7.x86_64 --> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.52-1.el7.x86_64 --> Processing Dependency: perl(Data::Dumper) for package: 1:mariadb-server-5.5.52-1.el7.x86_64 --> Processing Dependency: perl(DBI) for package: 1:mariadb-server-5.5.52-1.el7.x86_64 . . . Installed: mariadb.x86_64 1:5.5.52-1.el7 mariadb-server.x86_64 1:5.5.52-1.el7 Dependency Installed: perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBD-MySQL.x86_64 0:4.023-5.el7 perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7 Dependency Updated: mariadb-libs.x86_64 1:5.5.52-1.el7 Complete!
We have successfully installed the MariaDB MySQL server and MariaDB client packages. For information on starting the MariaDB service, see the following command.
[[email protected] ~]# systemctl start mariadb # Start the MariaDB MySQL Server Service
To check whether the MariaDB MySQL Server service is running or not, you can use the following command.
[[email protected] ~]# systemctl status mariadb # Confirm if MariaDB Service is Working or Not ● mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled) Active: active (running) since Sun 2017-08-06 13:01:56 IST; 23s ago Process: 20947 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS) Process: 20904 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS) Main PID: 20946 (mysqld_safe) CGroup: /system.slice/mariadb.service ├─20946 /bin/sh /usr/bin/mysqld_safe --basedir=/usr └─21162 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/... Aug 06 13:01:54 localhost.localdomain systemd: Starting MariaDB database server... Aug 06 13:01:55 localhost.localdomain mysqld_safe: 170806 13:01:55 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. Aug 06 13:01:55 localhost.localdomain mysqld_safe: 170806 13:01:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Aug 06 13:01:56 localhost.localdomain systemd: Started MariaDB database server.
Read also: Step by step recovery of a forgotten MySQL root password
For information on how to enable MariaDB MySQL Server service on startup, see the following command.
[[email protected] ~]# systemctl enable mariadb # Enable the MariaDB Service on Startup Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
Use the following command to confirm the installed MariaDB Server and MariaDB Client package.
[[email protected] ~]# rpm -qa | grep mariadb # Confirm the installed Package mariadb-5.5.52-1.el7.x86_64 mariadb-server-5.5.52-1.el7.x86_64 mariadb-libs-5.5.52-1.el7.x86_64
To check the version of the MariaDB that installed the package, we can use the following command.
[[email protected] ~]# mysql --version; # Check Version of MariaDB Database Server Package Version mysql Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1
In order to configure the MariaDB MySQL server as follows, set a root password for the MySQL server, remove anonymous users, prohibit remote login of the root … etc., we can use that mysql_secure_installation Command.
[[email protected] ~]# mysql_secure_installation # Configuring MariaDB Mysql Server 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 you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): ---> Just Press ENTER to continue as currently we don't have any root password OK, successfully used password, moving on... Setting the root password ensures that nobody can log into the MariaDB root user without the proper authorisation. Set root password? [Y/n] y # Enter "y" to Set root Password New password: Re-enter new password: Password updated successfully! Reloading privilege tables.. ... Success! 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 ---> Enter "y" If you want to remove Anonymous Users to login MariaDB MySQL Server ... 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 ---> Enter "y" to Disable root Login of MariaDB Database Server on Remote Access ... 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 ---> Enter "y" to remove all test Database's and access to it from MariaDB MySQL Server - 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 ---> Enter "y" reload Privilege Table ... 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!
Read also: How to install LAMP Stack with PhpMyAdmin in Ubuntu 18.04
We have successfully installed and configured the MariaDB MySQL Server & MariaDB Client. Now let’s log in to the MySQL server.
[[email protected] ~]# mysql -u root -p # Login MariaDB MySQL server using "root" Enter password: ---> Enter the Password of user "root" Welcome to the MariaDB monitor. Commands end with ; or g. Your MariaDB connection id is 10 Server version: 5.5.52-MariaDB MariaDB Server Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. MariaDB [(none)]> create database usersdb; # Create a New Database Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> show databases; # Show available Database's +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | usersdb | +--------------------+ 4 rows in set (0.00 sec) MariaDB [(none)]> use usersdb; # Changing the Database Database changed MariaDB [usersdb]> CREATE TABLE employees (employee_id int, name VARCHAR(15), address VARCHAR(300)); Query OK, 0 rows affected (0.01 sec) MariaDB [usersdb]> show tables; # Show available Table's in Database +-------------------+ | Tables_in_usersdb | +-------------------+ | employees | +-------------------+ 1 row in set (0.00 sec) # Insert Data in to the Table "employees" MariaDB [usersdb]> INSERT INTO employees (employee_id,name,address) VALUES(001,"shrikant","mumbai"); Query OK, 1 row affected (0.00 sec) MariaDB [usersdb]> INSERT INTO employees (employee_id,name,address) VALUES(002,"aditya","delhi"); Query OK, 1 row affected (0.00 sec) MariaDB [usersdb]> SELECT * FROM employees; # Retrieving Data from Table "employees" +-------------+----------+---------+ | employee_id | name | address | +-------------+----------+---------+ | 1 | shrikant | mumbai | | 2 | aditya | delhi | +-------------+----------+---------+ 2 rows in set (0.00 sec)
That’s all. In this article we have explained how to install Mariadb MySQL Server and Mariadb Client In Rhel 7 / Centos 7. I hope you like this article. If you like this article, just share it. If you have any questions about this article, please comment.