How To Install MariaDB on AlmaLinux 10

To install MariaDB on AlmaLinux 10, follow the steps below:

Step 1 : First, update all system packages:

sudo dnf update -y

Step 2 : Install MariaDB server and client packages:

sudo dnf install mariadb-server -y

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

sudo systemctl enable --now mariadb

Step 4 : Run the security script to harden your MariaDB installation:

sudo mysql_secure_installation

Follow the prompts as below:

- Enter current password for root: Press Enter (leave blank if no password is set)

- Switch to unix_socket authentication : Type y and press Enter

- Change the root password : Type y, then set a strong root password

- Remove anonymous users : Type y

- Disallow root login remotely : Type y

- Remove test database and access to it : Type y

- Reload privilege tables now : Type y



Step 5 : Verify that MariaDB is running:

sudo systemctl status mariadb

Step 6 : Log in to the MariaDB shell:

sudo mariadb

Step 7 : Create a new admin user and grant full privileges:

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

Exit MariaDB:

EXIT;

Congratulations! You have successfully installed, secured, and configured MariaDB on AlmaLinux 10.