阿里云centos7.4安装mysql5.7

    1.创建一个文件夹：mkdir /usr/local/mysql

    2.进入文件夹 cd /usr/local/mysql，下载RPM：wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

    3.安装源：yum localinstall mysql57-community-release-el7-11.noarch.rpm

    4.安装mysql：yum install mysql-community-server

    5.启动服务：systemctl start mysqld

    6.开机启动：systemctl enable mysqld; systemctl daemon-reload;

    7.查看临时密码：grep 'temporary password' /var/log/mysqld.log;

    8.mysql -uroot -p 登录mysql

    9.设置新密码：update user set authentication_string=password('新密码，大写字母+数字+字符') where user='root';

    10.遇到：You must reset your password using ALTER USER statement before executing this statement.

    11. SET PASSWORD = PASSWORD('自己设置密码');

    12. ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

    13. flush privileges;

    14.退出，重新登录。

    15.增加远程登录用户：mysql>grant all on *.* to 用户名@"%" identified by "密码";mysql>flush privileges;