centos7下安装MySQL,并且实现远程连接
1.先查看MySQL是否安装
rpm -qa|grep mysql
2.更新yum源
wget /get/mysql57-community-release-el7-9.noarch.rpm
3.rpm安装wget到的包
4.yum安装MySQL
yum install mysql-server
5.检查是否已经安装
rmp -qa|grep mysql
6.查看服务状态
systemctl status mysld
7.开启MySQL服务
systemctl start mysqld
8.再次查看MySQL的服务状态
systemctl status mysld
此时应该已经启动
9.获取临时密码
grep ‘temporary password’ /var/log/mysqld.log
10.使用临时密码登录MySQL
mysql -hlocalhost -u root -p
更改密码(为 @ABCdef123456,一般需要特殊字符+英文大小写+数字的组合)
(此时远程连接数据库不会成功,因为访问用户受限制),所以进行
11.数据库访问设置
use mysql;
show tables;
select host, user from user;
update user set host="%" where user=“root”;
刷新操作flush privileges;
12.防火墙设置
在阿里云服务器控制台中加入安全组 端口号为3306
尝试访问连接MySQL
(关闭MySQL语句: systemctl stop mysqld)