欢迎光临
我们一直在努力

R1-003 MySQL的rpm安装实例

1、解压tar包

[root@hhu MySQL]# tar -xvf mysql-5.7.17-1.el6.x86_64.rpm-bundle.tar

mysql-community-test-5.7.17-1.el6.x86_64.rpm

mysql-community-embedded-5.7.17-1.el6.x86_64.rpm

mysql-community-embedded-devel-5.7.17-1.el6.x86_64.rpm

mysql-community-server-5.7.17-1.el6.x86_64.rpm

mysql-community-libs-compat-5.7.17-1.el6.x86_64.rpm

mysql-community-devel-5.7.17-1.el6.x86_64.rpm

mysql-community-client-5.7.17-1.el6.x86_64.rpm

mysql-community-libs-5.7.17-1.el6.x86_64.rpm

mysql-community-common-5.7.17-1.el6.x86_64.rpm

[root@hhu MySQL]# ls

mysql-5.7.17-1.el6.x86_64.rpm-bundle.tar mysql-community-embedded-devel-5.7.17-1.el6.x86_64.rpm

mysql-community-client-5.7.17-1.el6.x86_64.rpm mysql-community-libs-5.7.17-1.el6.x86_64.rpm

mysql-community-common-5.7.17-1.el6.x86_64.rpm mysql-community-libs-compat-5.7.17-1.el6.x86_64.rpm

mysql-community-devel-5.7.17-1.el6.x86_64.rpm mysql-community-server-5.7.17-1.el6.x86_64.rpm

mysql-community-embedded-5.7.17-1.el6.x86_64.rpm mysql-community-test-5.7.17-1.el6.x86_64.rpm

2、卸载已有老版本MySQL

[root@hhu MySQL]# rpm -qa|grep mysql

mysql-5.1.71-1.el6.x86_64

mysql-devel-5.1.71-1.el6.x86_64

mysql-libs-5.1.71-1.el6.x86_64

[root@hhu MySQL]# rpm -e mysql-5.1.71-1.el6.x86_64

error: Failed dependencies:

mysql = 5.1.71-1.el6 is needed by (installed) mysql-devel-5.1.71-1.el6.x86_64

[root@hhu MySQL]# rpm -e mysql-devel-5.1.71-

[root@hhu MySQL]# rpm -qa|grep mysql

mysql-5.1.71-1.el6.x86_64

mysql-libs-5.1.71-1.el6.x86_64

[root@hhu MySQL]# rpm -e mysql-5.1.71-1.el6.x86_64

[root@hhu MySQL]# rpm -e mysql-libs-5.1.71-1.el6.x86_64

error: Failed dependencies:

libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64

libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64

mysql-libs is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64

[root@hhu MySQL]# rpm -e mysql-libs-5.1.71-1.el6.x86_64 –nodeps 强制卸载

[root@hhu MySQL]# rpm -qa|grep mysql

[root@hhu MySQL]#

3、安装MySQL包,一共5个,会有依赖关系,安装顺序如下:

rpm -Uvh mysql-community-common-5.7.17-1.el6.x86_64.rpm

rpm -Uvh mysql-community-libs-5.7.17-1.el6.x86_64.rpm

rpm -Uvh mysql-community-libs-compat-5.7.17-1.el6.x86_64.rpm

rpm -Uvh mysql-community-client-5.7.17-1.el6.x86_64.rpm

rpm -Uvh mysql-community-server-5.7.17-1.el6.x86_64.rpm

[root@hhu MySQL]# ls

mysql-5.7.17-1.el6.x86_64.rpm-bundle.tar mysql-community-embedded-devel-5.7.17-1.el6.x86_64.rpm

mysql-community-client-5.7.17-1.el6.x86_64.rpm mysql-community-libs-5.7.17-1.el6.x86_64.rpm

mysql-community-common-5.7.17-1.el6.x86_64.rpm mysql-community-libs-compat-5.7.17-1.el6.x86_64.rpm

mysql-community-devel-5.7.17-1.el6.x86_64.rpm mysql-community-server-5.7.17-1.el6.x86_64.rpm

mysql-community-embedded-5.7.17-1.el6.x86_64.rpm mysql-community-test-5.7.17-1.el6.x86_64.rpm

[root@hhu MySQL]# rpm -Uvh mysql-community-common-5.7.17-1.el6.x86_64.rpm

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

Preparing… ########################################### [100%]

1:mysql-community-common ########################################### [100%]

[root@hhu MySQL]# rpm -Uvh mysql-community-libs-5.7.17-1.el6.x86_64.rpm

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

Preparing… ########################################### [100%]

1:mysql-community-libs ########################################### [100%]

[root@hhu MySQL]# rpm -Uvh mysql-community-libs-compat-5.7.17-1.el6.x86_64.rpm

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

Preparing… ########################################### [100%]

1:mysql-community-libs-co########################################### [100%]

[root@hhu MySQL]# rpm -Uvh mysql-community-client-5.7.17-1.el6.x86_64.rpm

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

Preparing… ########################################### [100%]

1:mysql-community-client ########################################### [100%]

[root@hhu MySQL]# rpm -Uvh mysql-community-server-5.7.17-1.el6.x86_64.rpm

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

Preparing… ########################################### [100%]

1:mysql-community-server ########################################### [100%]

[root@hhu MySQL]# service mysqld status

mysqld is stopped

[root@hhu MySQL]# service mysqld start

Initializing MySQL database: [ OK ]

Installing validate password plugin: [ OK ]

Starting mysqld: [ OK ]

4、获取超级数据库用户临时密码,登录,修改密码

[root@hhu MySQL]# grep ‘temporary password’ /var/log/mysqld.log

2017-02-23T01:36:39.249352Z 1 [Note] A temporary password is generated for root@localhost: i7NmqxstDZ?L

[root@hhu MySQL]# mysql -uroot -p

Enter password:

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

Your MySQL connection id is 4

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> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyNewPass4!’;

Query OK, 0 rows affected (0.00 sec)


mysql> q
uit

Bye

赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。