How To Set up MariaDB on RHEL Eight

I am a brand new MariaDB and RHEL Eight consumer. How do I set up MariaDB on RHEL Eight server utilizing the yum command?

Introduction – MariaDB is a free and open supply database administration system. It acts as a drop alternative for Oracle MySQL server. It’s a neighborhood drive and developed department of Oracle MySQL. MariaDB is a multi-user, multi-threaded SQL database server. This web page explains find out how to set up the newest secure model of MariaDB on RHEL Eight server.

How one can set up MariaDB on RHEL Eight

The process to put in MariaDB on a Purple Hat Enterprise Linux Eight is as follows:

Open the terminal utility. Another choice is to log in utilizing the ssh command
ssh consumer@rhel-Eight-server-ipPutting in the MariaDB on RHEL Eight, sort:
sudo yum set up mariadb-serverSecuring the MariaDB server in RHEL Eight, run:
sudo mysql_secure_installationLastly check your set up by working:
mysql -u root -p

Allow us to see all steps in particulars.

Putting in MariaDB on RHEL Eight utilizing the yum command

Kind the next yum command:
$ sudo yum set up mariadb-server

How one can allow mariadb.service at RHEL Eight boot time

Run the next systemctl command:
$ sudo systemctl allow mariadb.service

Created symlink /and so forth/systemd/system/mysql.service ? /usr/lib/systemd/system/mariadb.service.
Created symlink /and so forth/systemd/system/mysqld.service ? /usr/lib/systemd/system/mariadb.service.
Created symlink /and so forth/systemd/system/multi-user.goal.needs/mariadb.service ? /usr/lib/systemd/system/mariadb.service.

Created symlink /and so forth/systemd/system/mysql.service ? /usr/lib/systemd/system/mariadb.service.
Created symlink /and so forth/systemd/system/mysqld.service ? /usr/lib/systemd/system/mariadb.service.
Created symlink /and so forth/systemd/system/multi-user.goal.needs/mariadb.service ? /usr/lib/systemd/system/mariadb.service.

How one can begin/cease/restart mariadb.service on RHEL Eight

Once more use the next syntax:
$ sudo systemctl cease mariadb.service
$ sudo systemctl begin mariadb.service
$ sudo systemctl restart mariadb.service
$ sudo systemctl standing mariadb.service
Click on to enlarge

How one can safe the MariaDB Server on RHEL Eight

You will need to safe the MariaDB server by working the next command for manufacturing use:
$ sudo mysql_secure_installation
Securing the MariaDB Server

How do I log in to the MariaDB server?

Use the mysql command as follows:
$ mysql -u root -p
Testing the MariaDB server set up
Above instructions signifies the set up has been profitable on RHEL Eight server. Now you can add customers and create databases in your functions written in PHP, Perl, Python and extra.

How one can add database on the MariaDB server

First, log in as root consumer:
$ mysql -u root -p mysql
Create a brand new MariaDB database known as nixcraft. Kind the next command at MariaDB> immediate:
CREATE DATABASE nixcraft;

How one can add customers on the MariaDB server

Create a brand new consumer known as vivek for database known as nixcraft:
GRANT ALL ON nixcraft.* TO vivek@localhost IDENTIFIED BY ‘secretePasswordHere’;

How to connect with the MariaDB database nixcraft utilizing vivek account

$ mysql -u vivek -p’secretePasswordHere’ nixcraft
OR
$ mysql -u vivek -p nixcraft

For additional info see:

Conclusion

You accomplished and secured MariaDB on RHEL Eight server. Additional, you discovered find out how to create customers and databases on the MariaDB server. For more information see MariaDB web site right here.

Posted by: Vivek Gite

The writer is the creator of nixCraft and a seasoned sysadmin, DevOps engineer, and a coach for the Linux working system/Unix shell scripting. Get the newest tutorials on SysAdmin, Linux/Unix and open supply subjects by way of RSS/XML feed or weekly electronic mail e-newsletter.

Source link