Linux安装mysql

1.下载安装包或者直接wget下载到指定目录

wget  https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar
1

2.上传服务器，并解压到指定目录

#进入安装包目录
cd /home/mysql-8.0.31
#解压命令
tar -xvf mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar 
1
2
3
4

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
1
2
3
4
5
6

4.修改mysql

4.1 启动mysql服务

systemctl start mysqld
1

4.2 获取首次启动生成的随机密码

sudo grep 'temporary password' /var/log/mysqld.log
1

4.3 登录mysql并修改密码

mysql -u root -p
1

更新密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPwd123';
1

4.4 开启允许root账户远程连接

# 切换使用mysql数据库
use mysql;
# 开启远程
update user set host='%' where user='root'; 
# 刷新权限
flush privileges;
1
2
3
4
5
6

4.5 退出mysql

quit;
1

5.开启防火墙端口允许访问

#查看防火墙状态
systemctl status firewalld 
#查看开放的端口
firewall-cmd --list-all 
#添加端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent 
#重载防火墙
firewall-cmd --reload 
#再次查看端口是否已经开放
firewall-cmd --list-all 
1
2
3
4
5
6
7
8
9
10