centos7 阿里云服务器安装mysql 配置远程访问

使用yum安装 mysql版本5.7

1.下载Yum Repository wget下载

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

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

2.安装mysql服务(稍微需要一点时间)

yum -y install mysql-community-server

3.启动mysql服务

systemctl start  mysqld.service

4.查看mysql启动状态

systemctl status mysqld.service

image.png

5.查询mysql随机生成的密码

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

image.png

6.进入mysql修改密码(默认强密码类型)

ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpassword';

7.授权远程访问权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword';

8.刷新权限

flush privileges;

9.测试远程访问连接（需要阿里云的安全组开放端口）