⑩① 详解Linux安装 MySQL 8.0【保姆级教程】

cd /usr/local/mysql

ls -l

rpm -ivh mysql-community-common-8.0.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm

yum install net-tools  #安装mysql-community-server前需要安装好的组件

rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm

systemctl status mysqld

systemctl start mysqld

systemctl enable mysqld

netstat -tunlp | grep mysql

# 查看Linux中已经启动的服务
netstat -tunlp

ps -ef | grep mysql

cat /var/log/mysqld.log | grep password
+f+g/qUCA0jc

# 登录mysql（回车后输入密码）【这里使用上面查询到的临时密码】
mysql -uroot -p

# 修改密码为123456
SHOW VARIABLES LIKE 'validate_password%';   #查看密码安全设置
set global validate_password_policy=LOW;    #设置密码安全等级为低
set global validate_password_length=4;      #设置密码至少长度为4
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

#开启访问权限：
# 1.创建用户root，密码123456
create USER 'root'@'%' IDENTIFIED BY '123456';
flush privileges; #刷新

# 2.给用户授权
grant all privileges on *.* to 'root'@'%';
flush privileges; #刷新

# 这里就需要修改root密码，如果不修改，密码就会被改为password
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;

# 密码与上一个命令保持一致
ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password BY '123456';

flush privileges; #刷新

# 关闭防火墙
systemctl stop firewalld

# 开启防火墙
systemctl start firewalld
# 开放3306端口
firewall-cmd --add-port=3306/tcp --permanent
# 刷新添加的端口
firewall-cmd --reload