• Home
  • Ubuntu 20.04
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us
TecAdmin
Menu
  • Home
  • Ubuntu 20.04
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us

How To Install MySQL 8.0 on Fedora 33/32/31

Written by Rahul, Updated on December 14, 2020

MySQL is a relational database management system. MySQL 8 is the latest version available for the installation on Linux systems.

If you need to install MySQL 5.7, the official repository provides packages up to Fedora 31. The latest Fedora version are recommended to use MySQL 8.0. Use other article to install MySQL 5.7 on Fedora 31/30 and earlier versions.

This tutorial will help you to install MySQL 8.0 on Fedora 33/32/31/30/29/28 systems.

Step 1 – Prerequisites

Login to your Fedora system and open a terminal. Now upgrade the current packages to the latest version by running the following command.

sudo dnf update

Step 2 – Setup Yum Repository

The MySQL team officially provides yum repository for the installation of MySQL community server on a Fedora systems. Create a new yum repository file using the content below:

vim /etc/yum.repos.d/mysql-community.repo
File: /etc/yum.repos.d/mysql-community.repo
[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

Save file and close.

Step 3 – Install MySQL Server

Now, run the following command to install the mysql-community-server packages on your Fedora system. This will also install all other required dependencies on your system.

sudo dnf install mysql-community-server

sudo systemctl enable mysqld.service
sudo systemctl start mysqld.service

Now, follow the post-installation instructions.

Step 4 – MySQL Post Installation Setup

The MySQL community server has been installed on your system. The installer will also generate a random password and set for the root user. You can find the root user password in log files.

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

2018-10-16T11:49:31.216147Z 1 [Note] A temporary password is generated for [email protected]: ,yJrusM58kW7

Now run the following command to apply security on MySQL server. Simply execute below command and follow the security wizard.

sudo mysql_secure_installation

Follow the onscreen instructions. Change your root account password and Press Y for all other operations to apply improved security.

  • Change the password for root? – Press y and change root password
  • Remove anonymous users? Press y
  • Disallow root login remotely? Press y
  • Remove test database and access to it? (Press y
  • Reload privilege tables now? Press y

Step 5 – Connect MySQL Terminal

All done. You can now connect to the MySQL server using the command line. The following command will connect MySQL running on the localhost as the root user. This will prompt for the root account password. You can also install LAMP stack on Fedora and configure PHPMyAdmin on fedora to access databases graphically.

mysql -u root -p

installing mysql 8 Fedora

This tutorial has been tested with the Fedora 30 system.

Share it!
Share on Facebook
Share on Twitter
Share on LinkedIn
Share on Reddit
Share on Tumblr
Share on Whatsapp
Rahul
Rahul
Connect on Facebook Connect on Twitter

I, Rahul Kumar am the founder and chief editor of TecAdmin.net. I am a Red Hat Certified Engineer (RHCE) and working as an IT professional since 2009..

9 Comments

  1. Avatar Will Reply
    September 15, 2020 at 1:31 pm

    hi, the ‘install LAMP stack on Fedora’ link at the bottom of the article doesn’t work.

    • Rahul Rahul Reply
      September 16, 2020 at 4:04 am

      Thanks Will, Link has been updated.

  2. Avatar uncle Reply
    May 22, 2020 at 3:33 pm

    solved secure login problem

  3. Avatar Daawud Bakare Reply
    March 15, 2020 at 2:15 am

    very many thanks brother.

  4. Avatar ECA Reply
    December 5, 2019 at 11:00 pm

    Cannot find temporary password generated in step 4. grep simply returns ‘Binary file /var/log/mysqld.log matches’.

  5. Avatar imm Reply
    October 11, 2019 at 12:55 pm

    Failed to enable unit: Unit file mysqld.service does not exist. when typing sudo systemctl enable mysqld.service

  6. Avatar Daniel Sobrinho Reply
    July 28, 2019 at 7:09 pm

    Thanks a lot my friend very usefull for me. I have this problem and this step help a lot.

  7. Avatar Powerhouse Reply
    April 21, 2019 at 1:45 am

    I get error when doing;

    sudo dnf install mysql-community-server

    warning: /var/cache/dnf/mysql80-community-4fbb8be86665a18d/packages/mysql-community-server-8.0.15-1.fc28.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Public key for mysql-community-server-8.0.15-1.fc28.x86_64.rpm is not installed
    Public key for mysql-community-common-8.0.15-1.fc28.x86_64.rpm is not installed
    Public key for mysql-community-client-8.0.15-1.fc28.x86_64.rpm is not installed
    Public key for mysql-community-libs-8.0.15-1.fc28.x86_64.rpm is not installed

    Please help.

    • Avatar Tisu Reply
      May 2, 2019 at 12:45 pm

      https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html

      Use this instead if you are still having this issue.

Leave a Reply Cancel reply

Popular Posts

  • How To Install Python 3.9 on Debian 10
  • Download Ubuntu 20.04 LTS – DVD ISO Images
  • Linux Run Commands As Another User
  • How to Check PHP Version (Apache/Nginx/CLI)
  • How To Install and Configure GitLab on Ubuntu 20.04
  • How to Install PyCharm on Ubuntu 20.04
  • How to Check Ubuntu Version with Command or Script
  • How to Set all directories to 755 And all files to 644
© 2013-2021 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy