CentOS7.4怎么用rpm包安装mysql5.7.17-创新互联

[root@iZ2ze6jo3o3bqbcongnyppZ ~]# rpm -ivh mysql-community-common-5.7.17-1.el7.x86_64.rpm

[root@iZ2ze6jo3o3bqbcongnyppZ ~]# rpm -ivh mysql-community-libs-5.7.17-1.el7.x86_64.rpm

[root@iZ2ze6jo3o3bqbcongnyppZ ~]# rpm -ivh mysql-community-libs-compat-5.7.17-1.el7.x86_64

[root@iZ2ze6jo3o3bqbcongnyppZ ~]# rpm -ivh mysql-community-devel-5.7.17-1.el7.x86_64

[root@iZ2ze6jo3o3bqbcongnyppZ ~]# rpm -ivh mysql-community-client-5.7.17-1.el7.x86_64.rpm

[root@iZ2ze6jo3o3bqbcongnyppZ ~]# rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm

[root@iZ2ze6jo3o3bqbcongnypoZ ~]# rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm

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

error: Failed dependencies:

    libaio.so.1()(64bit) is needed by mysql-community-server-5.7.17-1.el7.x86_64

    libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.17-1.el7.x86_64

    libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.17-1.el7.x86_64

[root@iZ2ze6jo3o3bqbcongnypoZ ~]# yum install libaio*

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

 * base: mirrors.cloud.aliyuncs.com

 * epel: mirrors.cloud.aliyuncs.com

 * extras: mirrors.cloud.aliyuncs.com

 * updates: mirrors.cloud.aliyuncs.com

Resolving Dependencies

--> Running transaction check

---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed

---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================================================================================================================================================

 Package Arch Version Repository Size

==============================================================================================================================================================================================================================================================================

Installing:

 libaio x86_64 0.3.109-13.el7 base 24 k

 libaio-devel x86_64 0.3.109-13.el7 base 13 k

Transaction Summary

==============================================================================================================================================================================================================================================================================

Install 2 Packages

Total download size: 37 k

Installed size: 46 k

Is this ok [y/d/N]: y

Downloading packages:

(1/2): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00 

(2/2): libaio-devel-0.3.109-13.el7.x86_64.rpm | 13 kB 00:00:00 

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Total 243 kB/s | 37 kB 00:00:00 

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

  Installing : libaio-0.3.109-13.el7.x86_64 1/2 

  Installing : libaio-devel-0.3.109-13.el7.x86_64 2/2 

  Verifying : libaio-0.3.109-13.el7.x86_64 1/2 

  Verifying : libaio-devel-0.3.109-13.el7.x86_64 2/2 

Installed:

  libaio.x86_64 0:0.3.109-13.el7 libaio-devel.x86_64 0:0.3.109-13.el7 

Complete!

[root@iZ2ze6jo3o3bqbcongnypqZ mysql]# cat /var/log/mysqld.log 

2017-11-03T08:41:25.257336Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2017-11-03T08:41:26.329912Z 0 [Warning] InnoDB: New log files created, LSN=45790

2017-11-03T08:41:26.543807Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2017-11-03T08:41:26.566468Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: c79a2e4b-c072-11e7-b809-00163e0ad76e.

2017-11-03T08:41:26.570349Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2017-11-03T08:41:26.571065Z 1 [Note] A temporary password is generated for root@localhost: 7PkQ:l

[root@iZ2ze6jo3o3bqbcongnyppZ ~]# systemctl start mysqld.service

[root@iZ2ze6jo3o3bqbcongnyppZ ~]# mysql -uroot -p

Enter password: 

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.7.17

Copyright (c) 2000, 2016, 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>

mysql> show databases;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

ALTER USER 'root'@'localhost' IDENTIFIED BY 'yournew_password';