centos7 安装mysql yum方式安装

最新推荐文章于 2020-12-31 13:31:31 发布

qq2531246791

最新推荐文章于 2020-12-31 13:31:31 发布

阅读量191

点赞数

CC 4.0 BY-SA版权

分类专栏： centos7

本文链接：https://blog.youkuaiyun.com/qq2531246791/article/details/79575332

centos7 专栏收录该内容

41 篇文章

订阅专栏

安装日志

获取yum安装服务

[root@master ~]# wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

--2017-02-19 16:56:24-- https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

正在解析主机 dev.mysql.com (dev.mysql.com)... 137.254.60.11

正在连接 dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... 已连接。

已发出 HTTP 请求，正在等待回应... 302 Found

位置：https://repo.mysql.com//mysql57-community-release-el7-9.noarch.rpm [跟随至新的 URL]

--2017-02-19 16:56:25-- https://repo.mysql.com//mysql57-community-release-el7-9.noarch.rpm

正在解析主机 repo.mysql.com (repo.mysql.com)... 184.31.66.242

正在连接 repo.mysql.com (repo.mysql.com)|184.31.66.242|:443... 已连接。

已发出 HTTP 请求，正在等待回应... 200 OK

长度：9224 (9.0K) [application/x-redhat-package-manager]

正在保存至: “mysql57-community-release-el7-9.noarch.rpm”

100%[========================================================================================>] 9,224 --.-K/s 用时 0.001s

2017-02-19 16:56:28 (14.4 MB/s) - 已保存 “mysql57-community-release-el7-9.noarch.rpm” [9224/9224])

// 查看下载的 yum 源

[root@master ~]# ll

总用量 116

-rw-------. 1 root root 1446 2月 12 21:32 anaconda-ks.cfg

-rw-r--r--. 1 root root 102166 6月 13 2016 b.html

drwxr-xr-x. 2 root root 174 2月 15 18:10 download

-rw-r--r--. 1 root root 9224 9月 12 21:05 mysql57-community-release-el7-9.noarch.rpm

drwxrwxrwx. 2 root root 134 2月 16 10:57 test

lrwxrwxrwx. 1 root root 4 2月 16 14:45 wwwlink -> /www

// 检查下载的 MD5 码

[root@master ~]# md5sum mysql57-community-release-el7-9.noarch.rpm

1a29601dc380ef2c7bc25e2a0e25d31e mysql57-community-release-el7-9.noarch.rpm

[root@master ~]# sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm

警告：mysql57-community-release-el7-9.noarch.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY

准备中... ################################# [100%]

正在升级/安装...

1:mysql57-community-release-el7-9 ################################# [100%]

// 安装 mysql 服务

[root@master ~]# yum install mysql-server

已加载插件：fastestmirror

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

mysql57-community | 2.5 kB 00:00:00

updates | 3.4 kB 00:00:00

(1/3): mysql-connectors-community/x86_64/primary_db | 13 kB 00:00:00

(2/3): mysql-tools-community/x86_64/primary_db | 32 kB 00:00:00

(3/3): mysql57-community/x86_64/primary_db | 96 kB 00:00:00

Loading mirror speeds from cached hostfile

* base: mirrors.btte.net

* extras: mirrors.btte.net

* updates: mirrors.btte.net

正在解决依赖关系

--> 正在检查事务

---> 软件包 mysql-community-server.x86_64.0.5.7.17-1.el7 将被安装

--> 正在处理依赖关系 mysql-community-common(x86-64) = 5.7.17-1.el7，它被软件包 mysql-community-server-5.7.17-1.el7.x86_64 需要

--> 正在处理依赖关系 mysql-community-client(x86-64) >= 5.7.9，它被软件包 mysql-community-server-5.7.17-1.el7.x86_64 需要

--> 正在检查事务

---> 软件包 mysql-community-client.x86_64.0.5.7.17-1.el7 将被安装

--> 正在处理依赖关系 mysql-community-libs(x86-64) >= 5.7.9，它被软件包 mysql-community-client-5.7.17-1.el7.x86_64 需要

---> 软件包 mysql-community-common.x86_64.0.5.7.17-1.el7 将被安装

--> 正在检查事务

---> 软件包 mariadb-libs.x86_64.1.5.5.52-1.el7 将被取代

--> 正在处理依赖关系 libmysqlclient.so.18()(64bit)，它被软件包 2:postfix-2.10.1-6.el7.x86_64 需要

--> 正在处理依赖关系 libmysqlclient.so.18(libmysqlclient_18)(64bit)，它被软件包 2:postfix-2.10.1-6.el7.x86_64 需要

---> 软件包 mysql-community-libs.x86_64.0.5.7.17-1.el7 将被舍弃

--> 正在检查事务

---> 软件包 mysql-community-libs-compat.x86_64.0.5.7.17-1.el7 将被舍弃

--> 解决依赖关系完成

依赖关系解决

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

Package 架构版本源大小

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

正在安装:

mysql-community-libs x86_64 5.7.17-1.el7 mysql57-community 2.1 M

替换 mariadb-libs.x86_64 1:5.5.52-1.el7

mysql-community-libs-compat x86_64 5.7.17-1.el7 mysql57-community 2.0 M

替换 mariadb-libs.x86_64 1:5.5.52-1.el7

mysql-community-server x86_64 5.7.17-1.el7 mysql57-community 162 M

为依赖而安装:

mysql-community-client x86_64 5.7.17-1.el7 mysql57-community 24 M

mysql-community-common x86_64 5.7.17-1.el7 mysql57-community 271 k

事务概要

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

安装 3 软件包 (+2 依赖软件包)

总下载量：190 M

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

Downloading packages:

警告：/var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.17-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY

mysql-community-common-5.7.17-1.el7.x86_64.rpm 的公钥尚未安装

(1/5): mysql-community-common-5.7.17-1.el7.x86_64.rpm | 271 kB 00:00:01

(2/5): mysql-community-libs-5.7.17-1.el7.x86_64.rpm | 2.1 MB 00:00:01

(3/5): mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm | 2.0 MB 00:00:01

(4/5): mysql-community-client-5.7.17-1.el7.x86_64.rpm | 24 MB 00:00:09

(5/5): mysql-community-server-5.7.17-1.el7.x86_64.rpm | 162 MB 00:01:44

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

总计 1.8 MB/s | 190 MB 00:01:48

从 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

软件包 : mysql57-community-release-el7-9.noarch (installed)

来自 : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

是否继续？[y/N]：y

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

警告：RPM 数据库已被非 yum 程序修改。

正在安装 : mysql-community-common-5.7.17-1.el7.x86_64 1/6

正在安装 : mysql-community-libs-5.7.17-1.el7.x86_64 2/6

正在安装 : mysql-community-client-5.7.17-1.el7.x86_64 3/6

正在安装 : mysql-community-server-5.7.17-1.el7.x86_64 4/6

正在安装 : mysql-community-libs-compat-5.7.17-1.el7.x86_64 5/6

正在删除 : 1:mariadb-libs-5.5.52-1.el7.x86_64 6/6

验证中 : mysql-community-common-5.7.17-1.el7.x86_64 1/6

验证中 : mysql-community-server-5.7.17-1.el7.x86_64 2/6

验证中 : mysql-community-libs-5.7.17-1.el7.x86_64 3/6

验证中 : mysql-community-libs-compat-5.7.17-1.el7.x86_64 4/6

验证中 : mysql-community-client-5.7.17-1.el7.x86_64 5/6

验证中 : 1:mariadb-libs-5.5.52-1.el7.x86_64 6/6

已安装:

mysql-community-libs.x86_64 0:5.7.17-1.el7 mysql-community-libs-compat.x86_64 0:5.7.17-1.el7

mysql-community-server.x86_64 0:5.7.17-1.el7

作为依赖被安装:

mysql-community-client.x86_64 0:5.7.17-1.el7 mysql-community-common.x86_64 0:5.7.17-1.el7

替代:

mariadb-libs.x86_64 1:5.5.52-1.el7

完毕！

[root@master ~]# mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[root@master ~]#

// 安装完成

// 开启mysql，并检查服务状态

[root@master ~]# sudo systemctl start mysqld

[root@master ~]# sudo systemctl status mysqld

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: active (running) since 日 2017-02-19 17:05:22 CST; 17s ago

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

Process: 2233 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

Process: 2160 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Main PID: 2237 (mysqld)

CGroup: /system.slice/mysqld.service

└─2237 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

2月 19 17:05:10 master.hadoop systemd[1]: Starting MySQL Server...

2月 19 17:05:22 master.hadoop systemd[1]: Started MySQL Server.

[root@master ~]#

// 查看mysql 的 root 的临时登录密钥

[root@master ~]# sudo grep 'temporary password' /var/log/mysqld.log

2017-02-19T09:05:15.654798Z 1 [Note] A temporary password is generated for root@localhost: JBwEtdw*B0tf

[root@master ~]#

// 配置用户

[root@master ~]# sudo mysql_secure_installation

// 查看mysql 版本

[root@master ~]# mysql -uroot -p version

Enter password:

ERROR 1049 (42000): Unknown database 'version'

[root@master ~]# mysqladmin -u root -p version

Enter password:

mysqladmin Ver 8.42 Distrib 5.7.17, for Linux on x86_64

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Server version 5.7.17

Protocol version 10

Connection Localhost via UNIX socket

UNIX socket /var/lib/mysql/mysql.sock

Uptime: 12 min 19 sec

Threads: 1 Questions: 20 Slow queries: 0 Opens: 113 Flush tables: 1 Open tables: 106 Queries per second avg: 0.027

[root@master ~]#