MariaDB is a popular, open-source relational database management system, known for being a drop-in replacement for MySQL. This guide will show you how to install and set up MariaDB on Fedora 33.
Solved: To install mysql or myriadb in fedora 33 is quite simple.
Step 1: For that open a terminal and simply type the following command.
dnf install mariadb-server -y
Step 2: In second step run the following commad to enable the firewall for mysql
firewall-cmd --add-service=mysql --permanent firewall-cmd --reload
Step 3: Now Install the security. This is step is very important and must login as root.
mysql_secure_installation
You’ll be asked a series of questions:
- Set a root password – Press Y and enter a new password.
- Remove anonymous users – Press Y.
- Disallow remote root login – Press Y.
- Remove test database – Press Y.
- Reload privilege tables – Press Y.
Just follow the instruction and continue.
Log in to the MariaDB shell to ensure it’s working:
sudo mysql -u root -p
After entering the password, you should see the MariaDB prompt:
Welcome to the MariaDB monitor. Commands end with ; or \g.
MariaDB [(none)]>
Run the following SQL commands to allow remote access for a specific user:
GRANT ALL PRIVILEGES ON *.* TO 'your_user'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION; FLUSH PRIVILEGES; exit;
Restart the MariaDB service:
sudo systemctl restart mariadb
Thats it.
Enjoy Mariadb.
