注:本教程以CentOS7为例,没错我就是那个爱折腾的人😜。
1、下载需要的rpm包
使用华为镜像分别下载 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
4、查看mysql默认生成的初始密码
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
完结撒花!!!