How To Install MariaDB on Fedora 39

To install MariaDB on Fedora 39, follow the steps outlined below.

Step 1 : Ensure that your system is up to date by running the following command:

sudo dnf update

Step 2 : Install MariaDB using the following command:

sudo dnf install mariadb-server

Step 3 : Start and enable MariaDB to run on system boot:

sudo systemctl start mariadb
sudo systemctl enable mariadb

Step 4 : Check the status of MariaDB to ensure it is running:

sudo systemctl status mariadb

Step 5 : Run the following command to secure your MariaDB installation:

sudo mysql_secure_installation

Follow these prompts:

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

- Switch to unix_socket authentication (choose 'y')

- Change the root password (choose 'y')

- Remove anonymous users (choose 'y')

- Disallow root login remotely (choose 'y')

- Remove the test database and access to it (choose 'y')

- Reload privilege tables now (choose 'y')

Step 6 : Access the MariaDB shell with the following command:

sudo mysql

Step 7 : Create a new administrative user and grant necessary 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 Fedora 39.