How to install mysql5.7 on centos7 using rpm

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 use Thunder to download, you must first find the corresponding rpm download path

First open the mysql official website in the browser:

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 paths of four rpm packages of myql5.7 are given below. You can directly open Thunder and fill in the download path to download. You can use the same method 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

The xshell I use here does not have xftp installed

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

3. Install

The rpm package that has been uploaded is as follows:

By rpm -ivhmysql-community-****-5.7.26-1.el7.x86_64.rpm--force --nodeps Installation, *** means common, libs, client, server

Installation sequence common-->libs-->client-->server

If there is no --force -- A warning will appear in nodeps:

　 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 the dlzmcrv?s2q found above)

Modify 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

The above is the detailed content of How to install mysql5.7 on centos7 using rpm. For more information, please follow other related articles on the PHP Chinese website!