Detailed tutorial on installing MariaDB on CentOS 8

MariaDB database management system is a branch of MySQL, mainly maintained by the open source community and licensed under the GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there was a potential risk of closing the source of MySQL, so the community adopted the branch method to avoid this risk. MariaDB is fully compatible with MySQL and the usage is the same.

System environment:

CentOS Linux release 8.1.1911 (Core)

1) Install mariaDB

2) Enable the service. After the installation is complete, you must first start the MariaDB service and set it to start at boot

systemctl start mariadb # Start the service systemctl enable mariadb # Set it to start automatically at boot

3) Initial configuration.

mysql_secure_installation

Enter current password for root (enter for none): # Enter the password of the database super administrator root (note that it is not the password of the system root). If you have not set a password for the first time, just press Enter Set root password? [Y/n] # Set a password, y

New password: # New passwordRe-enter new password: # Re-enter passwordRemove anonymous users? [Y/n] # Remove anonymous users, y

Disallow root login remotely? [Y/n] # Deny root remote login. n. Regardless of y/n, root remote login will be denied. Remove test database and access to it? [Y/n] # Delete the test database. y: delete. n: Do not delete. There will be a test database in the database, which is generally not needed. Reload privilege tables now? [Y/n] # Reload the privilege table, y. Or restart the service maybe

4) Test whether the login is successful.

mysql -u root -p

5) Set MariaDB character set to utf-8

. . . . . .

6) Remotely connect to the mariadb database

Enable remote access permissions

grant all on *.* to user03@'%' identified by '123456' with grant option

Force refresh permissions

flush privileges;

This is the end of this article about the detailed tutorial on how to install MariaDB on CentOS 8. For more information about installing MariaDB on CentOS 8, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!