centos7在线安装yum install mysql8
一、清理旧版本mysql
- 查看当前系统是否装有旧版的 MySQL
rpm -qa|grep -i mysql
- 存在则停止服务
service mysql stop
- 卸载第一步的结果,如
rpm -e --nodeps mysql-libs-8.0.31-1.el7.x86_64
- 查找老版本的mysql文件
find / -name mysql | grep docker
- 删除第四步的文件
rm -rf ..
- 再次 查看当前系统是否装有旧版的mysql
rpm -qa|grep -i mysql
二、在线安装
- 下载:
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
- 安装:
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
yum install mysql-server
-- 这里应该会有出现报错!如
Failing package is: mysql-community-server-8.0.31-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
--- 处理:
1. rpm --checksig /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm
2. 执行下面语句:
gpg --export -a 3a79bd29 > 3a79bd29.asc
rpm --import 3a79bd29.asc
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
- 重新执行安装命令
yum install mysql-server
---------------------------------安装完成---------------------
修改密码
- 启动服务
service mysqld start/status/stop
- 查看是否有初始密码
grep 'temorary password' /var/log/mysqld.log # 我这里没有结果;但是cat /var/log/mysqld.log是有密码的!!!
- 进入客户端
mysql -uroot -p初始密码
- 修改初始密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码'; # 新密码可以选择初始密码,然后改动若干个字符
-- 此处如果修改为简单密码会报错,如:
1.Your password does not satisfy the current policy requirements
- SHOW VARIABLES LIKE 'validate_password%';
set global validate_password.policy=0;
set global validate_password.policy=0;
- 设置完则可进行修改密码:alter user 'root'@'%' identified by 'thinker@'; # 此处使用ALTER会报错
- 授权远程登陆
use mysql;
update user set host = '%' where user = 'root';
- 刷新权限
FLUSH PRIVILEGES;
- 退出客户端重启。
service mysqld restart