MariaDB is an open source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. MariaDB is based on SQL and supports ACID-style data processing with guaranteed atomicity, consistency, isolation and durability for transactions.
yum install mariadb-server
Check the version of MariaDB server by following command.
Once the installation is complete, enable MariaDB using the commands below.
systemctl enable mariadb systemctl start mariadb systemctl status mariadb
You must secure the MariaDB server by running the following command.
To login to the MariaDB server, enter the following command with the password that was set previously,
mysql -u root -p
Let's create a new database with custom user and password.
First, log in as root user, then type the following commands:
mysql -u root -p CREATE DATABASE crowncloud; CREATE user username; GRANT ALL ON crowncloud.* TO username@localhost IDENTIFIED BY 'password'; exit
This concludes our topic of installing MariaDB on CentOS Stream 9 system.