CentOS7安装MySQL5.7

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
下载mysql源安装包

yum localinstall mysql57-community-release-el7-8.noarch.rpm
安装mysql源
按Y确认

yum repolist enabled | grep "mysql.*-community.*"
检查mysql源是否安装成功

yum install mysql-community-server
安装MySQL
按两次Y确认

systemctl start mysqld
启动MySQL服务
systemctl enable mysqld
systemctl daemon-reload
设置开机启动

grep ‘temporary password‘ /var/log/mysqld.log
查看默认密码

mysql -uroot -p
登录MySQL
输入默认密码

set password for ‘root‘@‘localhost‘=password(‘Abcdef@123456‘);
把默认密码修改为Abcdef@123456

grant all privileges on *.* to root@‘%‘ identified by ‘Abcdef@123456‘;
授予root账户外网登录权限

vim /etc/my.cnf
修改配置文件
在[mysqld]里面添加
character_set_server=utf8
init_connect=‘SET NAMES utf8‘

service mysqld restart
重启MySQL服务
mysql -uroot -p
登录MySQL
输入密码
show variables like ‘character%‘;
查看数据库编码方式

开启MySQL数据库3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

使用SQLyog连接MySQL

CentOS7安装MySQL5.7

原文：https://www.cnblogs.com/yjlch1016/p/8901550.html