How To Install MySQL 8 In Fedora 36 Linux TechRadar

mysql is one of the oldest and most trusted open source relational database management systems trusted by millions of users and used daily. Since Felt recently announced its new version of the flagship distribution, we will explain how you can easily install MySQL 8 in Fedora 36.

Throughout this tutorial we will be using the default Felt repositories so that we can make this installation process as easy as possible.

Important: mysql and MariaDB the packages provide similar files and will conflict with each other. For this reason, you should only install mysql Where MariaDB but not both.

Advertising

Install MySQL in Fedora Linux

Before installing a package on your system, updating your repositories and applying updates (if applicable) ensures a robust experience. We will update the repositories by the given dnf command:

$ sudo dnf update

Once the repositories are updated, we can move on to the installation part. Since we’ll be using the default repository, it saves us more complex steps. As we want to have the most recent version of mysqlwe will use the community version.

To install mysqluse the given command:

$ sudo dnf install community-mysql-server -y
Install MySQL in Fedora

As we use dnfit will automatically manage all dependencies and give us a hassle-free experience.

Start MySQL in Fedora Linux

I just installed mysql won’t do your job. Before we go any further, we need to enable mysql service because it will be in an idle state after installation.

To check the current status of the mysql service, use the given command:

$ systemctl status mysqld
Check MySQL Status
Check MySQL Status

We will use the following command to start the mysql service:

$ sudo systemctl start mysqld

Now let’s check if we started successfully mysql using the given command:

$ systemctl status mysqld
Check MySQL Status in Fedora
Check MySQL Status in Fedora

As you can see, mysql runs in an active state.

Likewise, if you want to start mysql on every boot, you can easily do this using the given command:

$ sudo systemctl enable mysqld

Securing MySQL in Fedora Linux

The default installation of mysql is weak by modern security standards and can easily be manipulated by hackers. There are several ways to secure your MySQL, but the simplest yet most effective is to use a secure script.

You can easily start the security script with the following command:

$ sudo mysql_secure_installation

For most users this script will work fine but if it asks you for the password you can retrieve a temporary password from mysqld.log at /var/log/ by the given command:

$ sudo grep 'temporary password' /var/log/mysqld.log

The secure script will ask you the following:

  • Configuring a root password
  • Deleting anonymous users
  • Disable root access via remote
  • Deleting the test database
  • Reloading root privileges
Securing MySQL in Fedora
Securing MySQL in Fedora

Connecting to MySQL in Fedora Linux

Once we are done securing the script, we can easily connect to the mysql server by the given command:

$ sudo mysql -u root -p
Connect to MySQL
Connect to MySQL

Once we are in mysqlwe can list databases using the following:

mysql> SHOW DATABASES;
List MySQL databases
List MySQL databases

Update MySQL in Fedora Linux

Despite the fact that we have just completed the installation recently, we can use the following command to update mysql some products:

$ sudo dnf update mysql-server
Update MySQL in Fedora
Update MySQL in Fedora

This was our take on how easily you can install MySQL 8 on Fedora 36 in the simplest way possible. But if you are still facing installation issues, feel free to ask in the comment section.

Similar Posts

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.