1、下载需要的rpm包注：本教程以CentOS7为例，没错我就是那个爱折腾的人。
使用华为镜像分别下载 MySQL5.7的common 、libs 、client 、server 4个RPM包：
wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-common-5.7.33-1.el6.x86_64.rpm wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-libs-5.7.33-1.el6.x86_64.rpm wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-client-5.7.33-1.el6.x86_64.rpm wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-server-5.7.33-1.el6.x86_64.rpm
2、安装4个RPM包
按照依赖顺序依次安装rpm包，依赖关系为common->libs->client->server
# --nodeps表示安装时不检查依赖关系 # --force 表示强制安装 rpm -ivh mysql-community-common-5.7.33-1.el6.x86_64.rpm --force --nodeps rpm -ivh mysql-community-libs-5.7.33-1.el6.x86_64.rpm --force --nodeps rpm -ivh mysql-community-client-5.7.33-1.el6.x86_64.rpm --force --nodeps rpm -ivh mysql-community-server-5.7.33-1.el6.x86_64.rpm --force --nodeps
3、启动MySQL服务
# 启动MySQL服务 service mysqld start # 扩展：关闭mysql服务命令 service mysqld stop # 查看MySQL服务状态 service mysqld status
cat /var/log/mysqld.log |grep password
5、登录MySQL服务器
mysql -uroot -pZeCkKsglg7+Z # mysql -u账号 -p密码
6、修改root登录密码
# 设置密码校验强度为最低级别 set global validate_password_policy=0; # 设置密码长度最少为4个字符 set global validate_password_length=4; # 修改密码 alter user 'root'@'localhost' identified by '123456'; # 刷新权限 flush privileges;
7、允许远程登录
# 查看mysql所有用户权限 select host,user from user; # 设置root账户允许远程登录访问 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; # 刷新权限 flush privileges;
ok ，我们可以远程访问啦！
数据库文件默认存储在/var/lib/mysql目录下。
解决：远程连接还是无法访问题（关闭防火墙或者开放3306端口）
# 关闭防火墙 systemctl stop firewalld.service # 设置开机禁用防火墙 systemctl disable firewalld.service # 检查防火墙状态 systemctl status firewalld
完结撒花！！！
