一、准备工作:
1. 先看CPU架构是x86是ARM
uname -m
2. 根据上面的架构下载对应的MySQL版本:(直接下载最大.tar压缩包,rpm依赖包全)
MySQL :: Download MySQL Community Serverhttps://dev.mysql.com/downloads/mysql/
二、安装:
1. 先解压,后安装一下顺序安装
tar xf mysql-8.0.29-1.el8.x86_64.rpm-bundle.tar
# 使用root安装
rpm -ivh mysql-community-common-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.29-1.el8.x86_64.rpm
rpm -ivh mysql-community-server-8.0.29-1.el8.x86_64.rpm
备注:安装后默认的配置文件路劲 /etc/my.cnf
三、修改Root密码 & 创建用户
root免密登录:(重新Root密码和创建用户后,注释掉 # skip-grant-tables)
vim /etc/my.cnf
# 加入一行
skip-grant-tables
# 启动mysql
systemctl start mysqld.service
# 查询启动状态
systemctl status mysqld.service
# 使用root用户登录
mysql -uroot
mysql> use mysql;
mysql> flush privileges;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
mysql> flush privileges;
# 创建新用户
mysql> CREATE USER 'myadmin'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
mysql> flush privileges;
mysql> quit;
备注:这里使用WITH mysql_native_password 旧密码加密方式。在MySQL8默认采用caching_sha2_password方式加密,该方式可能会引起Mysql Client连接工具链接不上的问题(错误号码2058 plugin caching_sha2_password could not be loaded)
四、注释掉免密登录和修改默认端口
vim /etc/my.cnf
# 去掉skip-grant-tables
# skip-grant-tables
# 加入一行
# 修改默认端口(3306 -> 3307)
port=3307
# 重启mysql:
systemctl restart mysqld.service
五、测试账号和密码
# mysql登录(使用新修改的密码)
mysql -uroot -p