Linux下yum安装MySQL 5.7.xx

//系统
# cat /etc/redhat-release 
CentOS release 6.8 (Final)
# uname -r
2.6.32-642.el6.x86_64

//下载安装rpm源包
# wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm
# rpm -ivh mysql57-community-release-el6-9.noarch.rpm
//或
# yum localinstall -y mysql57-community-release-el6-9.noarch.rpm
//安装MySQL
# yum -y install mysql-community-server
//初始的'root'@'localhost'密码会被存储在/var/log/mysqld.log
//查看初始密码
# grep 'temporary password' /var/log/mysqld.log
//启动
# /etc/init.d/mysqld start
//登录
# mysql -uroot -p

//修改初始密码
//要注意的是MySQL 5.7默认不能设置简单密码，需要包含字母大小写特殊字符，长度8位或以上
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'myNewPass18#';

//授权远程登录，若要精准授权把 % 更换为ip或网段地址即可
mysql>grant all privileges on *.* to 'slave'@'%' identified by 'myNewPass20#';
mysql>flush privileges;