mysql5.7 rpm-bundle安装过程及遇到的一些坑

1.去mysql官网下载安装包，然后解压
tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
解压完后会有以下包
mysql-community-embedded-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-test-5.7.28-1.el7.x86_64.rpm
mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.28-1.el7.x86_64.rpm
2.rpm安装
rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
3.启动mysql服务
查看mysql服务状态：service mysqld status --启动状态会显示running
启动mysql服务：service mysqld start
4.修改密码
a.通过：grep password /var/log/mysqld.log 可以查看临时密码。

A temporary password is generated for root@localhost:xxxxx

b.登录mysql

mysql -uroot -p

c.修改密码

mysql> set password = password("你的新密码");

5.开启远程连接，root是你的账户，访问root账户密码是123456，就是你设置root的密码。

         **以下方式是给任意IP授权，如果是公网机器请考虑安全性**

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

6.防火墙看下时候开通3306端口

======================== 几个坑 ============================
坑一： 安装common时候报很多conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x86_64这种依赖错误mariadb-libs，这个时候我们先用 rpm -qa|grep mariadb 查询一下
mariadb-5.5.60-1.el7_5.x86_64
mariadb-devel-5.5.60-1.el7_5.x86_64
mariadb-libs-5.5.60-1.el7_5.x86_64 --我们需要卸载掉这个，防止依赖冲突

卸载mariadb-libs,然后重新安装

rpm -e mariadb-libs-1:5.5.60-1.el7_5.x86_64 --nodeps

坑二： 安装client和server过程中如果报一下错误可以在安装命令结尾加上：–nodeps --force 忽略掉依赖检查

warning: mysql-community-client-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
	mariadb is obsoleted by mysql-community-client-5.7.28-1.el7.x86_64

rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm --nodeps --force

warning: mysql-community-server-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
	file /usr/bin/my_print_defaults from install of mysql-community-server-5.7.28-1.el7.x86_64 conflicts with file from package mariadb-1:5.5.60-1.el7_5.x86_64
	file /usr/share/man/man1/my_print_defaults.1.gz from install of mysql-community-server-5.7.28-1.el7.x86_64 conflicts with file from package mariadb-1:5.5.60-1.el7_5.x86_64

rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm --force --nodeps

坑三： 在进行密码重设的时候报
Your password does not satisfy the current policy requirements
表示不符合密码强度策略

mysql> set global validate_password_policy=LOW;  --设置为LOW只验证密码长度
mysql> set global validate_password_length=6;  --密码长度验证设置为6位

mysql> set password = password('123456'); --这样就可以了