CentOS7 uses rpm to install MySQL 5.7 tutorial diagram

1. Download 4 rpm packages

mysql-community-client-5.7.26-1.el7.x86_64.rpm
mysql-community-common-5.7.26-1.el7.x86_64.rpm
mysql-community-libs-5.7.26-1.el7.x86_64.rpm
mysql-community-server-5.7.26-1.el7.x86_64.rpm

If you want to download with Thunder, you must first find the corresponding rpm download path

First, open the MySQL official website in the browser: https://dev.mysql.com/downloads/mysql/5.7.html

In the opened interface, press F12 on the keyboard to open the developer tools. After opening, it is as follows:

Find the corresponding version on the official website:

Click to download directly:

You can find the download path in the developer tools:

The following are the paths of the 4 myql5.7 rpm packages. You can download them by directly opening Xunlei and filling in the download path. The same method can be used for other versions:

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-server-5.7.26-1.el7.x86_64.rpm

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-client-5.7.26-1.el7.x86_64.rpm

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-common-5.7.26-1.el7.x86_64.rpm

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-libs-5.7.26-1.el7.x86_64.rpm

2. Upload rpm to linux

I use xshell here, and xftp is not installed

Enter the put command in sftp and select the downloaded rpm package to upload:

3. Installation

The uploaded rpm is as follows:

Install through rpm -ivhmysql-community-****-5.7.26-1.el7.x86_64.rpm--force --nodeps , *** represents common, libs, client, server

Installation order common-->libs-->client-->server

If there is no --force --nodeps, a warning will appear:

warning: mysql-community-common-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

4. Configuration

Start the mysql service:

[root@localhost ~]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
[root@localhost ~]#

Find the initial password:

[root@localhost ~]# cat /var/log/mysqld.log |grep password
2019-06-02T08:39:38.448115Z 1 [Note] A temporary password is generated for root@localhost: dLZMCRv?s2q)
2019-06-02T08:40:41.870130Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)

Log in to mysql:

[root@localhost ~]# mysql -u root -p

The password is dLZMCRv?s2q found above)

Change the root password:

mysql> alter user 'root'@'localhost' identified by 'newpasswd';

Allow remote connections:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'newpasswd' WITH GRANT OPTION;
mysql> FLUSH PEIVLEGES;

Turn off the firewall:

[root@localhost ~]# systemctl stop firewalld.service

Summarize

The above is the tutorial illustration of how to install mysql5.7 using rpm on centos7 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!