安装mysql8.0.27-aarch64

---

1. 依次安装mysql依赖包以及mysql

rpm -ivh mysql-community-common-8.0.27-1.el7.aarch64

rpm -ivh mysql-community-client-plugins-8.0.27-1.el7.aarch64

rpm -ivh mysql-community-libs-8.0.27-1.el7.aarch64

rpm -ivh mysql-community-libs-compat-8.0.27-1.el7.aarch64

rpm -ivh mysql-community-devel-8.0.27-1.el7.aarch64

rpm -ivh mysql-community-client-8.0.27-1.el7.aarch64

rmp -ivh mysql-community-server-8.0.27-1.el7.aarch64

2. 启动(初始化)mysql
   #systemctl stsrt mysqld

初始化数据库修改密码

1. 进入配置文件my.cnf
   在[mysqld]添加：skip-grant-tables
2. 重启mysql
   systemctl restart mysqld
3. 进入数据库
   mysql -uroot -p
4. 刷新权限
   flush privileges;
5. 更改密码安全机制
   SHOW VARIABLES LIKE ‘validate_password%’;
   set global validate_password.policy=LOW;
   set global validate_password.number_count=0;
6. 刷新权限
   flush privileges;
7. 修改密码
   ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘你的密码’;
8. 注释配置文件

MySQL8无法连接navicat问题：

1. 进入mysql
2. 查看权限
   use mysql;
   select user,host from user;
3. 修改用户权限
   update user set host = ‘%’ where user = ‘root’ and host=‘localhost’;
4. 刷新权限
   flush privileges;
5. 报错1251
   如下
   ALTER USER ‘root’@’%’ IDENTIFIED BY ‘你的密码’ PASSWORD EXPIRE NEVER;
   重新设置密码；
   ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘你的密码’;
   刷新数据库
   flush privileges;