How To Install MariaDB on Rocky Linux 9

To install MariaDB on Rocky Linux 9, follow the steps below.

Step 1 : Update the package repository to ensure you have the latest information about available packages.

sudo dnf update

Step 2 : Install the MariaDB server package using the package manager.

sudo dnf install mariadb-server

Step 3 : Start the MariaDB service and enable it to start on boot.

sudo systemctl start mariadb
sudo systemctl enable mariadb

Step 4 : Secure MariaDB

- Run the MariaDB security script to enhance the security of your installation.

sudo mysql_secure_installation

Follow the on-screen prompts:

- Enter the root password (press Enter if not set).

- Switch to unix_socket authentication: Answer 'y'.

- Change the root password: Answer 'y' and set a strong password.

- Remove anonymous users: Answer 'y'.

- Disallow root login remotely: Answer 'y'.

- Remove the test database and access to it: Answer 'y'.

- Reload privilege tables now: Answer 'y'.

Step 5 :Check the status of the MariaDB service to ensure it is running.

sudo systemctl status mariadb

Step 6 : Access the MariaDB server with the MySQL command-line client.

sudo mysql

Step 7 : Create Admin and Grant Privileges

Inside the MariaDB shell, create an admin user and grant necessary privileges.

CREATE USER 'admin'@'localhost' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Congratulations! You have successfully installed and secured MariaDB on Rocky Linux 9.