CentOS安装Mysql5.7

下载MySQL5.7

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
yum -y install mysql-community-server

启动mysql
systemctl start mysqld
设置开机自启
systemctl enable mysqld
重新加载
systemctl daemon-reload

修改mysql配置文件

打开配置文件
vim /etc/my.cnf

# 添加以下代码到配置文件中
----------------------------------------------------------------------------------
# 设置为默认编码为utf8
character-set-server=utf8          
init_connect='SET NAMES utf8'
# 关闭密码安全策略，默认密码（数字、大小写、特殊字符）（正式环境建议开启）
validate_password=off 
-------------------------------------------------------------------------------
# 重启mysql
service mysqld restart

查看初始密码
grep "password" /var/log/mysqld.log
进入mysql
mysql -uroot -p

# 修改密码
alter user 'root'@'localhost' identified by 'password';
# 增加root用户指定可以任意IP登录，如果想限制只能让指定IP登录请把%替换成IP地址
grant all privileges on *.* to 'root'@'%' identified by 'password';
# 刷新权限
flush privileges;

默认配置文件路径：

配置文件：/etc/my.cnf 
日志文件：/var/log/var/log/mysqld.log 
服务启动脚本：/usr/lib/systemd/system/mysqld.service 
socket文件：/var/run/mysqld/mysqld.pid