一、下载mysql rpm 包
wge https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
二、使用rpm命令安装MySQL
sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
2.1、cd /etc/yum.repos.d/
2.2、yum repolist enabled | grep ‘mysql’
2.3、yum repolist all | grep mysql
三、选择MySQL部署版本(可默认)
3.1、 yum repolist all | grep mysql
3.2、sudo yum-config-manager --disable mysql80-community
3.3、选择5.7版本:sudo yum-config-manager --enable mysql57-community
四、安装MySQL服务:sudo yum install mysql-community-server
报错:
五、解决方式
5.1、使用网络安装
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
失败:error: https://repo.mysql.com/RPM-GPG-KEY-mysql-2022: import read failed(2).
5.2、更新秘钥
wge -q -O - https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 | apt-key add -
失败:-bash: apt-key: command not found
5.3、查看 https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 的内容发现是MySQL的秘钥;
5.4、查看/etc/yum.repos.d/mysql-community.repo文件获得MySQL秘钥的存放地址,并备份原秘钥文件
5.5、将 https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 的内容写入RPM-GPG-KEY-mysql当做秘钥
命令:wge -q -O - https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 > RPM-GPG-KEY-mysql
六、重新安装MySQL
七、启动、查看、关闭MySQL服务:
sudo service mysqld status\status\stop
八、修改密码:
MySQL第一次启动后会创建超级管理员账号root@localhost,初始密码存储在日志文件中:
grep ‘temporary password’ /var/log/mysqld.log
九、设置root用户远程访问
1、GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root@MySQL2022' WITH GRANT OPTION;
2、FLUSH PRIVILEGES;
执行命令报错:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
则先修改初始化密码
ALTER USER USER() IDENTIFIED BY 'Admin2023';
十、设置编码UFT-8
SHOW VARIABLES LIKE 'character%';