How To Install MySQL 5.7 on Fedora 30/29/28

Cpanel/Whm License $3/mo Plesk License $10/mo Cloudlinux License $5/mo

(: May 8, 2019)

Question: How can I install MySQL 5.7 on Fedora 30/29/28?. MySQL is the most robust production-grade RDBMS based on Structured Query Language (SQL). Its development is backed by Oracle Corporation. With its proven reliability, performance, and ease-of-use, MySQL has become the leading database choice for web-based applications.

Some big companies using MySQL includes Facebook, Twitter, YouTube, and many others. MySQL has a huge user community behind it, so you can always get help when you need one.

Step 1: Install MySQL 5.7 on Fedora 30/29/28

The packages for MySQL 5.7 are available on Oracle upstream repositories for Fedora. Add the repository using the following commands – specific to each distribution.

.td_uid_2_5d909227e0939_rand.td-a-rec-img{text-align:left}.td_uid_2_5d909227e0939_rand.td-a-rec-img img{margin:0 auto 0 0}

For Fedora 30:

sudo dnf -y install https://repo.mysql.com//mysql80-community-release-fc30-1.noarch.rpm

For Fedora 29:

sudo dnf -y install https://repo.mysql.com//mysql80-community-release-fc29-2.noarch.rpm

For Fedora 28:

sudo dnf -y install https://repo.mysql.com//mysql80-community-release-fc28-2.noarch.rpm

The commands above will add repository contents to the file /etc/yum.repos.d/mysql-community.repo.

The default package mysql-community-server installed is for MySQL 8. To install MySQL 5.7 on Fedora 30/29/28, first enable channel for MySQL 5.7.

sudo dnf --disablerepo=mysql80-community --enablerepo=mysql57-community install mysql-community-server

Press “y” key to start the installation.

...........................................
Transaction Summary
Install  49 Packages
Total download size: 214 M
Installed size: 970 M
Is this ok [y/N]: y

Also Agree to add GPG key.

Importing GPG key 0x5072E1F5:
 Userid     : "MySQL Release Engineering <[email protected]>"
 Fingerprint: A4A9 4068 76FC BD3C 4567 70C8 8C71 8D3B 5072 E1F5
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y

To view installed package specific details, use:

$ rpm -qi mysql-community-server
 Name        : mysql-community-server
 Version     : 5.7.26
 Release     : 1.fc29
 Architecture: x86_64
 Install Date: Wed 08 May 2019 06:56:53 PM CEST
 Group       : Applications/Databases
 Size        : 766402082
 License     : Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Under GPLv2 license as shown in the Description field.
 Signature   : DSA/SHA1, Mon 15 Apr 2019 11:21:42 AM CEST, Key ID 8c718d3b5072e1f5
 Source RPM  : mysql-community-5.7.26-1.fc29.src.rpm
 Build Date  : Sat 13 Apr 2019 04:54:54 PM CEST
 Build Host  : vigdis06.no.oracle.com
 Relocations : (not relocatable)
 Packager    : MySQL Release Engineering [email protected]
 Vendor      : Oracle and/or its affiliates
 URL         : http://www.mysql.com/
 Summary     : A very fast and reliable SQL database server

Step 2: Configure MySQL 5.7 on Fedora 30/29/28.

2.1 – After the installation, start mysqld service.

sudo systemctl enable --now mysqld.service

2.2 – Copy the generated random password for the root user

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

Take note of the printed password:

2019-05-08T16:59:02.412078Z 1 [Note] A temporary password is generated for [email protected]: -gv9kyqud*,U

2.3 – Start MySQL Secure Installation to change the root password, Disallow root login remotely, remove anonymous users and remove test database.

$ sudo mysql_secure_installation
Securing the MySQL server deployment.
Enter password for user root:

Authenticate with your generated temporary password. This will ask you to set a new password for the root user.

Change the password for root ? ((Press y|Y for Yes, any other key for No) : Yes

New password: 
Re-enter new password: 

Estimated strength of the password: 100 
Do you wish to continue with the password provided?: Yes

Remove anonymous users?: Yes
Success.

Disallow root login remotely? : Yes
Success.

Remove test database and access to it? : Yes
 - Dropping test database...
Success.
 - Removing privileges on test database...
Success.

Reload privilege tables now? (Press y|Y for Yes) : Yes
Success.

All done!

You can use online password generator to get a complex password.

2.4 – Connect to MySQL Database as root user and create a test database.

$ mysql -u root -p
Enter password: <Enter Root Password>
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 15
Server version: 5.7.26 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> 

2.5 – Create a test database and user:

mysql> CREATE DATABASE test_db;
Query OK, 1 row affected (0.09 sec)

mysql> CREATE USER 'test_user'@'localhost' IDENTIFIED BY "Strong34S;#";
Query OK, 0 rows affected (0.04 sec)

mysql> GRANT ALL PRIVILEGES ON test_db.* TO 'test_user'@'localhost';
Query OK, 0 rows affected (0.02 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.02 sec)

This test database and user can be dropped by running:

mysql> DROP DATABASE test_db;
Query OK, 0 rows affected (0.14 sec)

mysql> DROP USER 'test_user'@'localhost';
Query OK, 0 rows affected (0.11 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql> QUIT
Bye

Step 3: Configure Firewall

To allow for remote connections, allow port 3306 on the firewall

sudo firewall-cmd --add-service=mysql --permanent
sudo firewall-cmd --reload

You can also limit access from trusted networks

sudo firewall-cmd --permanent --add-rich-rule 'rule family="ipv4" 
service name="mysql" source address="10.10.10.0/24" accept'

Thanks for installing MySQL 5.7 on Fedora 30/29/28 using our guide. Until next time, stay connected.

Other MySQL articles:

How To Install MySQL 8 on Fedora

How to convert all MySQL tables from MyISAM into InnoDB Storage engine

How to solve “MySQL server is running with the –secure-file-priv” Error

How to find database sizes in MySQL/MariaDB Database Server

.td_uid_4_5d909227e0b2d_rand.td-a-rec-img{text-align:left}.td_uid_4_5d909227e0b2d_rand.td-a-rec-img img{margin:0 auto 0 0}

Related posts

Bitfury Research Shines Light on Bitcoin Privacy Weaknesses

SXI ADMIN

Inside Bitcoins Conference Descends on Las Vegas Next Week

SXI ADMIN

Overstock Will Pay Some of Its 2019 Taxes in Bitcoin

SXI ADMIN

Financial Stability Board: Blockchain Could Raise Cross-Border Data Issues

SXI ADMIN

New York Regulator May Impose Technology Restrictions on Digital Currencies

SXI ADMIN

HODL On: In Defense of Bitcoin’s Best Strategy

SXI ADMIN

Google Search Study Hints at ‘Shady Truth’ of Bitcoin Users

SXI ADMIN

Amazon Subsidiary Registers Cryptocurrency and Ethereum Domains

SXI ADMIN

Remove a Domain from our Email Hosting Service

SXI ADMIN

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More