# 完全卸载mariadb
yum remove mariadb
rpm -qa | grep mariadb
rpm -e mariadb-libs-5.5.65-1.el7.x86_64 --nodeps
rm -f /etc/my.cnf
rm -rf /var/lib/mysql/
# 用163的源，分开安装, or yum安装
wget https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-common-8.0.20-1.el7.x86_64.rpm
wget https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-libs-8.0.20-1.el7.x86_64.rpm
wget https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-client-8.0.20-1.el7.x86_64.rpm
wget https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-server-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-common-8.0.20-1.el7.x86_64.rpm # rpm下载
rpm -ivh mysql-community-libs-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.20-1.el7.x86_64.rpm
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql-community-server
systemctl start mysqld.service
systemctl status mysqld.service
# 重启Mysql
service mysqld start
# 查看Mysql默认密码
cat /var/log/mysqld.log | grep password
# 登录
mysql -A -uroot -p # 回车，复制上面的密码即可
# 连接mysql之前，先修改下root的密码
set global validate_password.policy=0; #修改策略
set global validate_password.length=1;
alter user 'root'@'localhost' identified with mysql_native_password by '6YcnClvi&r%^2#';
# 测试环境，密码可以简单点，Mysql8.0必须用mysql_native_password给账号加密
# 修改root账号的Host，便于IP连接
use mysql;
update user set Host = '%' where User='root';
flush privileges;
# 查看mysql的安装信息
ps -ef | grep mysql
# mysql8 查看所有用户
select host,user from mysql.user;
# mysql8:
use mysql；
drop user ihunter@'%'; # 删除
drop user root@'%'; # 删除
create user ihunter@'%' identified by '***'; # 增加
grant all privileges on *.* to ihunter@'%' with grant option;
ALTER USER ihunter@'%' IDENTIFIED WITH mysql_native_password BY '***'; # 修改密码 or 解决1045异常.
flush privileges;
SET PASSWORD FOR 'ihunter'@'%' = PASSWORD("***"); # 修改密码
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('m'); # 修改密码
