How To Install MariaDB on Fedora 40

To Install MariaDB on Fedora 40, you need to follow these steps:

Step 1 : Update

sudo dnf update

Step 2 : Install MariaDB

sudo dnf install mariadb-server

Step 3 : Start and Enable MariaDB

sudo systemctl start mariadb
sudo systemctl enable mariadb

Step 4 : Secure MariaDB

sudo mysql_secure_installation

Follow the prompts:

- Enter 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 test database and access to it: y

- Reload privilege tables now: y

Step 5 : Check Status

sudo systemctl status mariadb

Step 6 : Access MariaDB

sudo mysql

Step 7 : Create Admin and Grant 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 MariaDB on Fedora 40 and secured it.