Install the Percona version of MySQL 5.7 on the Aliyun host by Yum mode

Aliyun Host Environment: cpu:1c mem:2g Os:centos 6.8

1. Install the Percona package source

Yum Install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/A2/8D/wKioL1miUyXjou1RAAB4Fkw-17k534.png-wh_500x0-wm_ 3-wmp_4-s_577377642.png "style=" Float:none; "title=" 1.png "alt=" Wkiol1miuyxjou1raab4fkw-17k534.png-wh_50 "/>

2. Verifying the Percona package source

Yum List | grep percona-server-server-57

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/A2/8D/wKioL1miUyWB0BogAABV6tCUe4Q265.png-wh_500x0-wm_ 3-wmp_4-s_3422498970.png "title=" 2.png "style=" Float:none; alt= "Wkiol1miuywb0bogaabv6tcue4q265.png-wh_50"/>

3. Install MySQL 5.7

Yum Install percona-server-server-57

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/03/DD/wKiom1miUzWziL6HAAD-kRRNplY499.png-wh_500x0-wm_ 3-wmp_4-s_3605829272.png "title=" 3.png "style=" Text-align:center;float:none; "alt=" Wkiom1miuzwzil6haad-krrnply499.png-wh_50 "/>

After the installation is complete, you will be prompted to install Percona Toolkit, can be uneasy, according to their own needs.

4. Reset MySQL database root user password

Mysql5.7 after the installation is complete, you cannot log in directly with the MySQL command, and the system does not provide a fixed initial password. As shown in the following:

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M00/A2/8D/wKioL1miUyajHPKzAABBHyqL6xU979.png-wh_500x0-wm_ 3-wmp_4-s_3579555100.png "title=" 4.png "style=" Float:none; alt= "Wkiol1miuyajhpkzaabbhyql6xu979.png-wh_50"/>

So how do I log in to the MySQL database? mysql5.7 after the installation is complete, the log file is actually provided with an initial password, we open the log file can be found.

First, we start and initialize the database

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M00/03/DD/wKiom1miUzaDwiwgAAAkXtgIpsM635.png-wh_500x0-wm_ 3-wmp_4-s_710520626.png "title=" 5.png "style=" Float:none; alt= "Wkiom1miuzadwiwgaaakxtgipsm635.png-wh_50"/>

Second, open the MySQL log file and find the system's initial password

Less/var/log/mysqld.log

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M00/A2/8D/wKioL1miUyez6h7dAAFDkBBtJP8406.png-wh_500x0-wm_ 3-wmp_4-s_907145365.png "title=" 6.png "style=" Float:none; alt= "Wkiol1miuyez6h7daafdkbbtjp8406.png-wh_50"/>

The highlight in the figure is our initial password, and we use that password to log in to the database

Mysql-uroot-pxjlt-:sh,9qa

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/03/DD/wKiom1miUzeD3cOAAABpkZYbvXc353.png-wh_500x0-wm_ 3-wmp_4-s_1459729752.png "title=" 7.png "style=" Float:none; alt= "Wkiom1miuzed3coaaabpkzybvxc353.png-wh_50"/>
Note: You must modify the initial password after logging in to make subsequent user and Rights management operations

5, modify the initial temporary password

Alter user ' root ' @ ' localhost ' identified by ' Your_new_password ';

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M01/A2/8D/wKioL1miUyeiKE0cAAAjWj-p1gw906.png-wh_500x0-wm_ 3-wmp_4-s_53354717.png "title=" 8.png "style=" Float:none; alt= "Wkiol1miuyeike0caaajwj-p1gw906.png-wh_50"/>

6, open a new terminal window, using the modified password to log in to the database, you can do normal database creation and management operations, so that MySQL installation is complete.

This article is from the "getg8642" blog, make sure to keep this source http://getg8642.blog.51cto.com/247171/1959695

Install the Percona version of MySQL 5.7 on the Aliyun host by Yum mode