How to Install MariaDB on Ubuntu 24.10

To install MariaDB on Ubuntu 24.10, follow these simple steps:

Step 1 : Run the following command to update the package lists:

sudo apt update

Step 2 : Install MariaDB using:

sudo apt install mariadb-server -y

Step 3 : Run the security script to improve MariaDB's default settings:

sudo mariadb-secure-installation

- Enter the root password (leave blank if not set).

- Switch to UNIX socket authentication: y

- Change the root password: y

- Remove anonymous users: y

- Disallow root login remotely: y

- Remove the test database: y

- Reload privilege tables: y

Step 4 : Ensure MariaDB starts on boot and is running:

sudo systemctl start mariadb
sudo systemctl enable mariadb

Step 5 : Verify that MariaDB is active:

sudo systemctl status mariadb

Step 6 : Log in to the MariaDB shell:

sudo mysql

Step 7 : Create a new admin user with full privileges:

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

Congratulations! You have successfully installed and configured MariaDB on Ubuntu 24.10.