How to Install MySQL Community Server on Fedora 30

It’s been a while I am not posting articles in this blog. And today, I am going to start by installing the MySQL Community Server on my new Fedora 30 Server. Fedora 30 is now available and I am going to build a personal MySQL database server with this distribution. In this tutorial, we are going to install MySQL version 8.0 on Fedora 30 Server edition.

Install MySQL Community Server on Fedora 30

Step 1 – Prerequisites

Before we actually install MySQL on Fedora 30, first we would recommend installing any available updates. The following command will perform the system update on Fedora 30.

su
dnf update

Step 2 – Setup Repository

By default, the MySQL Community edition is not available in Fedora 30 repository. We need to set up this repo manually. Use nano or vi to edit the repo. In this case, I use nano.

Create a new repofile

/etc/yum.repos.d/mysql-community.repo

Now copy and paste the following lines to the new repo file

 [mysql80-community]
 name=MySQL 8.0 Community Server
 baseurl=http://repo.mysql.com/yum/mysql-8.0-community/fc/$releasever/$basearch/
 enabled=1

Now save and close the file

Step 3 – Install MySQL Server

Now we have set up the repository and then we can start installing the MySQL server package.

dnf install mysql-community-server

Now the download and installation process will take place. Allow some times to complete. After the installation is completed, we need to start the service and enable the service at system boot.

systemctl enable mysqld.service
systemctl start mysqld.service

Step 4 – Post Installation

The MySQL Community Server is now installed on the Fedora 30. But we still need to configure it before we can use it. During the installation, the installer creates a random root password. We need to obtain this password.

grep 'A temporary password is generated' /var/log/mysqld.log | tail -1

Output:

2019-06-23T13:26:04.502239Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: r1E=D,iX,,5D

Now we can use the password to login to MySQL and then change the root password. Now execute this command

mysql_secure_installation

Follow on-screen wizard, you will need to provide the existing root password and you can change the root password as well.

Conclusion

Now we have a working MySQL Server on Fedora 30. It took some steps but I think its pretty easy to follow though. I hope you enjoy the tutorial to install mysql community server on Fedora 30 and leave us comments if you have some queries.