Linux：安装mysql8

Linux：安装mysql8

1. 安装 MySQL 依赖

[root@localhost ~]# yum install perl net-tools -y

2. 卸载 mariadb (系统自带的数据库)

[root@localhost ~]# rpm -qa | grep mariadb # 查看

[root@localhost ~]# rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64 # 卸载

3. 安装 MySQL (顺序不能乱)

安装过程出现报错,可以在命令最后加上 --nodeps 不检查依赖项

[root@localhost software]# tar -xvf mysql-8.0.25-1.el7.x86_64.rpm-bundle.tar # 解压

[root@localhost software]# rpm -ivh mysql-community-common-8.0.25-1.el7.x86_64.rpm

[root@localhost software]# rpm -ivh mysql-community-client-plugins-8.0.25-1.el7.x86_64.rpm # 没有跳过

[root@localhost software]# rpm -ivh mysql-community-libs-8.0.25-1.el7.x86_64.rpm

[root@localhost software]# rpm -ivh mysql-community-client-8.0.25-1.el7.x86_64.rpm

[root@localhost software]# rpm -ivh mysql-community-server-8.0.25-1.el7.x86_64.rpm

4. 启动 mysqld 服务

[root@localhost ~]# systemctl start mysqld

5. 查找初始密码并登录 MySQL

查找初始密码

[root@localhost ~]# cat /var/log/mysqld.log | grep password

登录 MySQL

[root@localhost ~]# mysql -u root -p

6. 修改MySQL密码 8.0版本 输入命令

修改 MySQL 密码 5.7 版本输入命令:

set global validate_password_policy = LOW;
set global validate_password_length = 6 ;
alter user root@localhost identified by ‘123456’ ;

7. 更改加密方式

mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’ PASSWORD EXPIRE NEVER;

mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;

8. 刷新权限

mysql> FLUSH PRIVILEGES;

9. 修改 MySQL 连接地址

mysql> use mysql;

mysql> update user set host=’%’ where user = ‘root’; // 更新

mysql> commit; // 提交

mysql> exit; // 退出

10. 重启 MySQL 服务生效配置

[root@localhost ~]# systemctl restart mysqld

11. 使用 Navicat 连接 MySQL

12. Navicat连接mysql 可能会遇到的问题

（1）防火墙没有释放3306端口

[root@localhost ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent;// 释放端口

[root@localhost ~]# firewall-cmd --reload // 刷新配置

(2) 直接关闭防火墙

[root@localhost ~]# systemctl stop firewalld //关闭防火墙

[root@localhost ~]# systemctl disable firewalld //禁用防火墙