How to Install MySQL on Fedora 29

How to Install MySQL on Fedora 29
How to Install MySQL on Fedora 29

Install MySQL on Fedora 29

MySQL is one of the most popular opensource database management systems. MySQL is a relational database system. It is part of LAMP (Linux, Apache, MySQL, PHP) stack and LEMP (Linux, Apache, MySQL, PHP) stack. In this tutorial, you are going to learn how to install MySQL on Fedora 29.

Prerequisites

Before you start to install MySQL on Fedora 29. You must have the root user account credentials of your system.

Install MySQL

Following are the steps to install MySQL on Fedora. First, you need to enable mysql repository and then you can install MySQL-Server on Fedora.

First you should create a new yum repository, to do so run following command:

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

Now paste following code inside above file the press Ctrl+x to save and exit file.

[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/fc/$releasever/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

To install mysql on Fedora run following command:

sudo yum install mysql-community-server

Now confirm the installation and check MySQL version typing following command:

mysql -V

After completing installation MySQL will start automatically. Check MySQL version by typing:

sudo systemctl status mysql

The output should be:

● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Wed 2019-05-01 11:30:23 PDT; 5min ago
 Main PID: 17382 (mysqld)
    Tasks: 27 (limit: 2321)
   CGroup: /system.slice/mysql.service
           `-17382 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid

You can log in to MariaDB by typing

mysql -u root -p

Setting Up MySQL

After installation, we have to improve MySQL security by typing the following:

sudo mysql_secure_installation

The above command will take you to different prompts. In the first prompt, it will ask you to configure Validate Password Plugin which is used to set password validation strength and the levels are low, medium and high. You can prefer any of the strength levels you want to set. If you don’t want to set up the Validate Password Plugin just press ENTER. In the next prompts, you will be asked questions about increasing Security of MySQL. It is recommended to answer ‘Y’ for all questions asked during secure installation.

Conclusion

You have successfully learned how to install MySQL on Fedora 29. If you have any queries please don’t forget to comment out.

LEAVE A REPLY

Please enter your comment!
Please enter your name here