一、运行环境
树莓派4B安装的CentOS 7.9(因树莓派使用的arm架构,本文也是基于arm版本的MySQL8.0 安装)
二、安装步骤
1、查看是否安装mariadb 并卸载
#查看是否存在数据库
rpm -qa | grep mariadb*
#卸载原装数据库
yum -y remove mari*
#查看是否安装过mysql
rpm -qa | grep mysql*
#如果有卸载
yum -y remove mysql*
rm -rf /var/lib/mysql/*
2、下载MySQL 8.0 RPM安装版本
#安装依赖
yum -y install libaio
#按照顺序安装
rpm -ivh mysql-community-common-8.0.27-1.el7.aarch64.rpm
rpm -ivh mysql-community-client-plugins-8.0.27-1.el7.aarch64.rpm --force --nodeps
rpm -ivh mysql-community-libs-8.0.27-1.el7.aarch64.rpm
rpm -ivh mysql-community-client-8.0.27-1.el7.aarch64.rpm
rpm -ivh mysql-community-server-8.0.27-1.el7.aarch64.rpm
安装完成后进行如下步骤
#启动mysql
systemctl start mysqld #(比较慢)
#查看状态
systemctl status mysqld
#查看初始密码
cat /var/log/mysqld.log | grep password
MySQL 简单配置更改
#使用root 登录
mysql -u root -p
#更改密码
ALTER user 'root'@'localhost' IDENTIFIED BY 'Merelyb-123456'; //大小写加数字和特殊字符
#开启远程连接权限
use mysql;
#查看连接权限
select host,user from user;
#更新远程连接权限
update user set host='%' where user ='root';
#刷新权限以便权限生效
flush privileges;
#查看mysql8 密码加密规则
show variables like "default_authentication%";
#更新密码加密规则以适应低版本连接
alter user 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Liming-5258';