云服务器CentOs7安装MySQL5.7并远程登录

1、下载

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

2、安装

yum -y install mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql-community-server

3、登录

启动mysql服务

systemctl start  mysqld.service

查看服务状态

systemctl status mysqld.service

停止和重启

systemctl stop mysqld
systemctl restart mysqld

找到root用户密码

grep "password" /var/log/mysqld.log

用这个密码登录Mysql

mysql -u root -p

4、更改服务配置

修改密码，注意新密码必须包含大小写字母、数字和特殊符号

ALTER USER 'root'@'localhost' IDENTIFIED BY 'We123456!';

开启mysql的远程访问,刷新

grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
flush privileges; 
exit;

5、远程连接

前往服务器控制台开放3306端口

测试连接