centos7安装mysql5.7

1. 安装mysql

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm 

查看原文件是否安装成功
yum repolist enabled | grep "mysql.*-community.*"

yum install mysql-community-server

2. 这里有个坑，5.7版本的user表是没有password字段的，初始密码在/var/log/mysqld.log（找不到密码，参考：https://www.cnblogs.com/zhongyehai/p/10683900.html）
3. 设置远程前需要重置密码。重置密码需要先降低安全基数

set global validate_password_policy=LOW;
#重置密码
alter user user() identified by "123456";

4. 设置远程可以访问

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

5. 设置默认字符编码，不区分大小写

/etc/my.cnf

[mysql]
default-character-set=utf8
 
[mysqld]
character-set-server=utf8

[mysqld]
lower_case_table_names=1