CentOS 7 安装MySQL

CentOS 7 安装MySQL

1.使用yum 安装mysql，需要使用mysql的yum仓库，先从官网下载
http://dev.mysql.com/downloads/repo/yum/

CentOS 7 使用的是：mysql57-community-release-el7-11.noarch.rpm

2.安装mysql仓库：

[root@localhost ~]# yum localinstall mysql57-community-release-el7-11.noarch.rpm
已加载插件：fastestmirror,
langpacks 正在检查 mysql57-community-release-el7-11.noarch.rpm:
mysql57-community-release-el7-11.noarch
mysql57-community-release-el7-11.noarch.rpm 将被安装 正在解决依赖关系
–> 正在检查事务
—> 软件包 mysql57-community-release.noarch.0.el7-11 将被 安装
–> 解决依赖关系完成 base/7/x86_64 | 3.6 kB 00:00:00 base/7/x86_64/group_gz
| 155 kB 00:00:00 base/7/x86_64/primary_db
| 5.6 MB 00:00:01 extras/7/x86_64
| 3.4 kB 00:00:00 extras/7/x86_64/primary_db
| 167 kB 00:00:00 updates/7/x86_64
| 3.4 kB 00:00:00 updates/7/x86_64/primary_db
| 5.7 MB 00:00:01

依赖关系解决

============================================================================================================================================================================================================================================ Package 架构
版本 源
大小
============================================================================================================================================================================================================================================ 正在安装: mysql57-community-release
noarch el7-11
/mysql57-community-release-el7-11.noarch
31 k

事务概要
============================================================================================================================================================================================================================================ 安装 1 软件包

总计：31 k 安装大小：31 k Is this ok [y/d/N]: y Downloading packages: Running
transaction check Running transaction test Transaction test succeeded
Running transaction 正在安装 :
mysql57-community-release-el7-11.noarch
1/1 验证中 : mysql57-community-release-el7-11.noarch
1/1

已安装: mysql57-community-release.noarch 0:el7-11

完毕！

3.安装最新的mysql-community-server

[root@localhost ~]# yum install -y mysql-community-server
已加载插件：fastestmirror, langpacks Loading mirror speeds from cached
hostfile 正在解决依赖关系
–> 正在检查事务
—> 软件包 mysql-community-server.x86_64.0.5.7.18-1.el7 将被 安装
–> 正在处理依赖关系 mysql-community-common(x86-64) = 5.7.18-1.el7，它被软件包 mysql-community-server-5.7.18-1.el7.x86_64 需要
–> 正在处理依赖关系 mysql-community-client(x86-64) >= 5.7.9，它被软件包 mysql-community-server-5.7.18-1.el7.x86_64 需要
–> 正在检查事务
—> 软件包 mariadb.x86_64.1.5.5.50-1.el7_2 将被 取代
—> 软件包 mysql-community-client.x86_64.0.5.7.18-1.el7 将被 舍弃
–> 正在处理依赖关系 mysql-community-libs(x86-64) >= 5.7.9，它被软件包 mysql-community-client-5.7.18-1.el7.x86_64 需要
—> 软件包 mysql-community-common.x86_64.0.5.7.18-1.el7 将被 安装
–> 正在检查事务
—> 软件包 mariadb-libs.x86_64.1.5.5.50-1.el7_2 将被 取代
–> 正在处理依赖关系 libmysqlclient.so.18()(64bit)，它被软件包 1:net-snmp-5.7.2-24.el7_2.1.x86_64 需要
–> 正在处理依赖关系 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.18-1.el7 将被 舍弃
–> 正在检查事务
—> 软件包 mysql-community-libs-compat.x86_64.0.5.7.18-1.el7 将被 舍弃
—> 软件包 net-snmp.x86_64.1.5.7.2-24.el7_2.1 将被 升级
—> 软件包 net-snmp.x86_64.1.5.7.2-24.el7_3.2 将被 更新
–> 正在处理依赖关系 net-snmp-libs = 1:5.7.2-24.el7_3.2，它被软件包 1:net-snmp-5.7.2-24.el7_3.2.x86_64 需要
–> 正在处理依赖关系 net-snmp-agent-libs = 1:5.7.2-24.el7_3.2，它被软件包 1:net-snmp-5.7.2-24.el7_3.2.x86_64 需要
–> 正在检查事务
—> 软件包 net-snmp-agent-libs.x86_64.1.5.7.2-24.el7_2.1 将被 升级
—> 软件包 net-snmp-agent-libs.x86_64.1.5.7.2-24.el7_3.2 将被 更新
—> 软件包 net-snmp-libs.x86_64.1.5.7.2-24.el7_2.1 将被 升级
–> 正在处理依赖关系 net-snmp-libs = 1:5.7.2-24.el7_2.1，它被软件包 1:net-snmp-utils-5.7.2-24.el7_2.1.x86_64 需要
—> 软件包 net-snmp-libs.x86_64.1.5.7.2-24.el7_3.2 将被 更新
–> 正在检查事务
—> 软件包 net-snmp-utils.x86_64.1.5.7.2-24.el7_2.1 将被 升级
—> 软件包 net-snmp-utils.x86_64.1.5.7.2-24.el7_3.2 将被 更新
–> 解决依赖关系完成

……
完毕！

4.启动mysqld：

[root@localhost ~]# service mysqld start

5.查看mysql的状态

[root@localhost ~]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
6月 16 17:41:10 localhost.localdomain systemd[1]: Starting MySQL Server…
6月 16 17:41:14 localhost.localdomain systemd[1]: Started MySQL Server.

6.用root用户登录
msyql在安装过程种，会随机生成root的密码，在mysqld.log中有记录，

[root@localhost ~]# cat /var/log/mysqld.log | grep password
2017-06-16T09:41:10.582223Z 1 [Note] A temporary password is generated for root@localhost: J1>Fno8!yZJU

[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.18

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

需要先修改密码，否则任何操作都会提示错误：

mysql> status
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> SET PASSWORD = PASSWORD(‘123456’);
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> SET PASSWORD = PASSWORD(‘1q2w3e’);
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> SET PASSWORD FOR ‘root’@’localhost’=”GpshzCccms2”;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> SET PASSWORD FOR ‘root’@’localhost’=”GpshzCccms-2”;
Query OK, 0 rows affected (0.00 sec)

7.常用命令

mysql> show databases;
mysql> use mysql;
mysql> show tables;
mysql> desc dbip_lookup;
mysql> drop table dbip_lookup;

8.开放远程访问权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'GpshzCccms-2' WITH GRANT OPTION;  
FLUSH PRIVILEGES;

至此，安装配置完成，可以进行后续操作。