centos7安装MySQL-rpm安装

centos7 安装mysql5.7

1 下载rpm包

通过浏览器下载官方rpm包

https://dev.mysql.com/downloads/mysql/5.7.html#downloads
下载包为：
mysql-community-server-5.7.28-1.el7.x86_64.rpm
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm

卸载mariadb

# rpm -qa |  grep mariadb
mariadb-libs-1:5.5.52-1.el7.x86_64
# rpm -e mariadb-libs-1:5.5.52-1.el7.x86_64 --nodeps

2 安装mysql

common-> libs-> client->server

# 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 --force --nodeps

3 启动mysql

# systemctl start mysqld

4 开机启动

# systemctl enable mysqld

5 修改root本地登录密码

5.1 获取临时密码

$ grep 'temporary password' /var/log/mysqld.log
2019-06-17T08:07:04.775619Z 1 [Note] A temporary password is generated for root@localhost: 6?qrG;ClOP7A

5.2 登录

$ mysql -u root -p

5.3 修改密码

（5.5+版本默认的密码策略2：字母大小写、数字、特殊字符）

mysql> set password = password("密码");

非生产测试环境，想使用简单的密码，可以先修改密码策略

查看密码策略
mysql> show variables like 'validate_password%';
*可以选择修改密码策略* 
Poliy	performed
0 or LOW	length
1 or MEDIUM	length; numeric, lowercase/uppercase, and special characters
2 or STRONG	length; numeric, lowercase/uppercase, and special characters
修改密码策略
mysql> set global validate_password_policy=0;
修改密码最低长度
mysql> set global validate_password_length=6;
修改密码
mysql> alter user 'root'@'localhost' identified by '密码';
Query OK, 0 rows affected (0.00 sec)

6 添加远程登录用户

创建用户

host='localhsot'    本地登录用户
host='ip' ip地址登录
host='%' 外网ip登录
mysql> create user 'hadoop'@'localhost' identified by '123456';

设置远程登录

mysql> grant all privileges on *.* to 'hadoop'@'linux01' identified by '123456' with grant option;
mysql> grant all privileges on *.* to 'hadoop'@'%' identified by '123456' with grant option;