Fedora is a great distribution. It is a very used distribution although not as much as Ubuntu or Linux Mint. However, it is still a reference for its bold innovations. Well, many developers choose it to carry out their projects or to incursionar in the programming. So, learning to install MySQL on Fedora 34/33 becomes quite necessary for this purpose. So that’s what this article is all about.
As we already know since Oracle took over MySQL many Linux distributions, they took it out of their official repositories. This resulted in the incorporation of a fork called MariaDB. In terms of compatibility everything is guaranteed but it is true that many developers still prefer to use MySQL. So, you have to use another repository for it.
Install MySQL on Fedora 34/33
Oracle provides us with a repository to install MySQL. Specifically, version 8.0 is loaded with interesting new features. So, the first step is to open a terminal session and execute the following command to add the MySQL repository.
For Fedora 34
:~$ sudo dnf install https://dev.mysql.com/get/mysql80-community-release-fc34-1.noarch.rpm
For Fedora 33:
:~$ sudo dnf install https://dev.mysql.com/get/mysql80-community-release-fc33-1.noarch.rpm
Then, once the repository is correctly added, we can install MySQL with the following command:
:~$ sudo dnf install mysql-community-server
And already, but before using it you have to make a few small configurations.
Using MySQL
MySQL is already installed, but you have to start the service to use it. So, run this command:
:~$ sudo systemctl start mysqld
If you want MySQL to start along with the system, use this other command as well:
:~$ sudo systemctl enable mysqld
For security reasons, MySQL generates a temporary root key. Please note that MySQL has even stricter security policies than MariaDB.
Then, you have to show which is the temporary password generated to be able to run the mysql_secure_installation script and be able to set a definite root key.
To do this, use the following command:
:~$ sudo cat /var/log/mysqld.log
In the image you can see, the generated key. Remember that in each case, it is different.
Then we can use the mysql_secure_installation script. In this script we will be able to set the definitive root password and make other security settings for the server.
:~$ sudo mysql_secure_installation
Enter the temporary key you previously obtained and you will immediately be able to establish yours.
MySQL has a plugin that does not allow weak passwords, so it establishes a strong one with numbers, signs and combinations of lower and uppercase letters.
Then, answer the security questions as you prefer. I said yes to all of them.
Now, you can use MySQL without problems. To do this, access the console with this command:
:~$ sudo mysql -u root -p
So, enjoy it.
Conclusion
MySQL continues to be the reference of the database relations handlers in Linux. However, as it is not present in the official repositories of Linux distributions, you have to take extra steps to install it.
