[root@mysql03 ~]# jps
14883 Jps [root@mysql03 ~]# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm --2017-03-13 10:14:13-- http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm 正在解析主机 dev.mysql.com (dev.mysql.com)... 137.254.60.11 正在连接 dev.mysql.com (dev.mysql.com)|137.254.60.11|:80... 已连接。 已发出 HTTP 请求，正在等待回应... 301 Moved Permanently 位置：https://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm [跟随至新的 URL] --2017-03-13 10:14:19-- https://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm 正在连接 dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... 已连接。 已发出 HTTP 请求，正在等待回应... 302 Found 位置：https://repo.mysql.com//mysql-community-release-el7-5.noarch.rpm [跟随至新的 URL] --2017-03-13 10:14:21-- https://repo.mysql.com//mysql-community-release-el7-5.noarch.rpm 正在解析主机 repo.mysql.com (repo.mysql.com)... 23.8.231.210 正在连接 repo.mysql.com (repo.mysql.com)|23.8.231.210|:443... 已连接。 已发出 HTTP 请求，正在等待回应... 200 OK 长度：6140 (6.0K) [application/x-redhat-package-manager] 正在保存至: “mysql-community-release-el7-5.noarch.rpm” 100%[==========================================================================================================>] 6,140 --.-K/s 用时 0s 2017-03-13 10:14:27 (761 MB/s) - 已保存 “mysql-community-release-el7-5.noarch.rpm” [6140/6140]) [root@mysql03 ~]# rpm -ivh mysql-community-release-el7-5.noarch.rpm 准备中... ################################# [100%] 正在升级/安装... 1:mysql-community-release-el7-5 ################################# [100%] [root@zoe03 ~]# yum install mysql-community-server 已加载插件：fastestmirror, langpacks base | 3.6 kB 00:00:00 extras | 3.4 kB 00:00:00 mysql-connectors-community | 2.5 kB 00:00:00 mysql-tools-community | 2.5 kB 00:00:00 mysql56-community | 2.5 kB 00:00:00 updates | 3.4 kB 00:00:00 (1/5): mysql-connectors-community/x86_64/primary_db | 13 kB 00:00:09 (2/5): mysql-tools-community/x86_64/primary_db | 32 kB 00:00:09 (3/5): mysql56-community/x86_64/primary_db | 159 kB 00:00:09 (4/5): updates/7/x86_64/primary_db | 3.8 MB 00:00:09 (5/5): extras/7/x86_64/primary_db | 139 kB 00:00:10 Determining fastest mirrors * base: mirrors.zju.edu.cn * extras: mirrors.zju.edu.cn * updates: mirrors.btte.net 正在解决依赖关系 --> 正在检查事务 ---> 软件包 mysql-community-server.x86_64.0.5.6.35-2.el7 将被 安装 --> 正在处理依赖关系 mysql-community-common(x86-64) = 5.6.35-2.el7，它被软件包 mysql-community-server-5.6.35-2.el7.x86_64 需要 --> 正在处理依赖关系 mysql-community-client(x86-64) >= 5.6.10，它被软件包 mysql-community-server-5.6.35-2.el7.x86_64 需要 --> 正在处理依赖关系 perl(Data::Dumper)，它被软件包 mysql-community-server-5.6.35-2.el7.x86_64 需要 --> 正在处理依赖关系 perl(DBI)，它被软件包 mysql-community-server-5.6.35-2.el7.x86_64 需要 --> 正在检查事务 ---> 软件包 mysql-community-client.x86_64.0.5.6.35-2.el7 将被 安装 --> 正在处理依赖关系 mysql-community-libs(x86-64) >= 5.6.10，它被软件包 mysql-community-client-5.6.35-2.el7.x86_64 需要 ---> 软件包 mysql-community-common.x86_64.0.5.6.35-2.el7 将被 安装 ---> 软件包 perl-DBI.x86_64.0.1.627-4.el7 将被 安装 --> 正在处理依赖关系 perl(RPC::PlServer) >= 0.2001，它被软件包 perl-DBI-1.627-4.el7.x86_64 需要 --> 正在处理依赖关系 perl(RPC::PlClient) >= 0.2000，它被软件包 perl-DBI-1.627-4.el7.x86_64 需要 ---> 软件包 perl-Data-Dumper.x86_64.0.2.145-3.el7 将被 安装 --> 正在检查事务 ---> 软件包 mysql-community-libs.x86_64.0.5.6.35-2.el7 将被 安装 ---> 软件包 perl-PlRPC.noarch.0.0.2020-14.el7 将被 安装 --> 正在处理依赖关系 perl(Net::Daemon) >= 0.13，它被软件包 perl-PlRPC-0.2020-14.el7.noarch 需要 --> 正在处理依赖关系 perl(Net::Daemon::Test)，它被软件包 perl-PlRPC-0.2020-14.el7.noarch 需要 --> 正在处理依赖关系 perl(Net::Daemon::Log)，它被软件包 perl-PlRPC-0.2020-14.el7.noarch 需要 --> 正在处理依赖关系 perl(Compress::Zlib)，它被软件包 perl-PlRPC-0.2020-14.el7.noarch 需要 --> 正在检查事务 ---> 软件包 perl-IO-Compress.noarch.0.2.061-2.el7 将被 安装 --> 正在处理依赖关系 perl(Compress::Raw::Zlib) >= 2.061，它被软件包 perl-IO-Compress-2.061-2.el7.noarch 需要 --> 正在处理依赖关系 perl(Compress::Raw::Bzip2) >= 2.061，它被软件包 perl-IO-Compress-2.061-2.el7.noarch 需要 ---> 软件包 perl-Net-Daemon.noarch.0.0.48-5.el7 将被 安装 --> 正在检查事务 ---> 软件包 perl-Compress-Raw-Bzip2.x86_64.0.2.061-3.el7 将被 安装 ---> 软件包 perl-Compress-Raw-Zlib.x86_64.1.2.061-4.el7 将被 安装 --> 解决依赖关系完成 依赖关系解决 ==================================================================================================================================================== Package 架构 版本 源 大小 ==================================================================================================================================================== 正在安装: mysql-community-server x86_64 5.6.35-2.el7 mysql56-community 59 M 为依赖而安装: mysql-community-client x86_64 5.6.35-2.el7 mysql56-community 19 M mysql-community-common x86_64 5.6.35-2.el7 mysql56-community 257 k mysql-community-libs x86_64 5.6.35-2.el7 mysql56-community 2.0 M perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k perl-DBI x86_64 1.627-4.el7 base 802 k perl-Data-Dumper x86_64 2.145-3.el7 base 47 k perl-IO-Compress noarch 2.061-2.el7 base 260 k perl-Net-Daemon noarch 0.48-5.el7 base 51 k perl-PlRPC noarch 0.2020-14.el7 base 36 k 事务概要 ==================================================================================================================================================== 安装 1 软件包 (+10 依赖软件包) 总下载量：82 M 安装大小：353 M Is this ok [y/d/N]: y Downloading packages: 警告：/var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.35-2.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY mysql-community-common-5.6.35-2.el7.x86_64.rpm 的公钥尚未安装 (1/11): mysql-community-common-5.6.35-2.el7.x86_64.rpm | 257 kB 00:00:08 (2/11): mysql-community-libs-5.6.35-2.el7.x86_64.rpm | 2.0 MB 00:00:01 (3/11): mysql-community-client-5.6.35-2.el7.x86_64.rpm | 19 MB 00:00:18 (4/11): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:11 (5/11): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00 (6/11): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:11 (7/11): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00 (8/11): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00 (9/11): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00 (10/11): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00 (11/11): mysql-community-server-5.6.35-2.el7.x86_64.rpm | 59 MB 00:00:24 ---------------------------------------------------------------------------------------------------------------------------------------------------- 总计 2.4 MB/s | 82 MB 00:00:34 从 file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 检索密钥 导入 GPG key 0x5072E1F5: 用户ID : "MySQL Release Engineering <mysql-build@oss.oracle.com>" 指纹 : a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5 软件包 : mysql-community-release-el7-5.noarch (installed) 来自 : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 是否继续？[y/N]：y Running transaction check Running transaction test Transaction test succeeded Running transaction 警告：RPM 数据库已被非 yum 程序修改。 ** 发现 2 个已存在的 RPM 数据库问题， 'yum check' 输出如下： 2:postfix-2.10.1-6.el7.x86_64 有缺少的需求 libmysqlclient.so.18()(64bit) 2:postfix-2.10.1-6.el7.x86_64 有缺少的需求 libmysqlclient.so.18(libmysqlclient_18)(64bit) 正在安装 : mysql-community-common-5.6.35-2.el7.x86_64 1/11 正在安装 : perl-Data-Dumper-2.145-3.el7.x86_64 2/11 正在安装 : mysql-community-libs-5.6.35-2.el7.x86_64 3/11 正在安装 : mysql-community-client-5.6.35-2.el7.x86_64 4/11 正在安装 : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 5/11 正在安装 : perl-Net-Daemon-0.48-5.el7.noarch 6/11 正在安装 : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 7/11 正在安装 : perl-IO-Compress-2.061-2.el7.noarch 8/11 正在安装 : perl-PlRPC-0.2020-14.el7.noarch 9/11 正在安装 : perl-DBI-1.627-4.el7.x86_64 10/11 正在安装 : mysql-community-server-5.6.35-2.el7.x86_64 11/11 ] 11/11 warning: /etc/my.cnf created as /etc/my.cnf.rpmnew 验证中 : mysql-community-client-5.6.35-2.el7.x86_64 1/11 验证中 : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 2/11 验证中 : perl-Net-Daemon-0.48-5.el7.noarch 3/11 验证中 : perl-Data-Dumper-2.145-3.el7.x86_64 4/11 验证中 : mysql-community-libs-5.6.35-2.el7.x86_64 5/11 验证中 : mysql-community-common-5.6.35-2.el7.x86_64 6/11 验证中 : perl-PlRPC-0.2020-14.el7.noarch 7/11 验证中 : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 8/11 验证中 : perl-DBI-1.627-4.el7.x86_64 9/11 验证中 : perl-IO-Compress-2.061-2.el7.noarch 10/11 验证中 : mysql-community-server-5.6.35-2.el7.x86_64 11/11 已安装: mysql-community-server.x86_64 0:5.6.35-2.el7 作为依赖被安装: mysql-community-client.x86_64 0:5.6.35-2.el7 mysql-community-common.x86_64 0:5.6.35-2.el7 mysql-community-libs.x86_64 0:5.6.35-2.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7完毕！
[root@mysql03 ~]# service mysqld restart Redirecting to /bin/systemctl restart mysqld.service [root@mysql03 ~]# mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.35-log MySQL Community Server (GPL) 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> set password for 'root'@'localhost' = password('root'); Query OK, 0 rows affected (0.00 sec) mysql> exit Bye [root@mysql03 ~]# mysql -uroot -proot Warning: Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.6.35-log MySQL Community Server (GPL) 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> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+ 3 rows in set (0.00 sec)
mysql> grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql>
