服务器版本 | mysql版本 |
---|---|
centos7 | mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar |
1.下载安装包或者直接wget下载到指定目录
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar
2.上传服务器,并解压到指定目录
#进入安装包目录
cd /home/mysql-8.0.31
#解压命令
tar -xvf mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar
3.顺序执行rpm命令
rpm -ivh mysql-community-common-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.31-1.el7.x86_64.rpm
4.修改mysql
4.1 启动mysql服务
systemctl start mysqld
4.2 获取首次启动生成的随机密码
sudo grep 'temporary password' /var/log/mysqld.log
4.3 登录mysql并修改密码
mysql -u root -p
更新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPwd123';
4.4 开启允许root账户远程连接
# 切换使用mysql数据库
use mysql;
# 开启远程
update user set host='%' where user='root';
# 刷新权限
flush privileges;
4.5 退出mysql
quit;
5.开启防火墙端口允许访问
#查看防火墙状态
systemctl status firewalld
#查看开放的端口
firewall-cmd --list-all
#添加端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
#重载防火墙
firewall-cmd --reload
#再次查看端口是否已经开放
firewall-cmd --list-all