CentOS7怎样安装MySQL5.7.22

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

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

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

 

rm -rf mysql57-community-release-el7-8.noarch.rpm

安装完成之后删除rpm包

 

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

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账户外网登录权限

flush privileges;
刷新权限表

 

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

最新的版本是5.7.27