centos7 安装mysql8

1. 删除旧版本

rpm -e --nodeps mysql
yum remove mariadb-libs.x86_64

2. 创建文件目录

mkdir /opt/soft

3. 下载rpm（可官网自己选版本 https://dev.mysql.com/downloads/repo/yum/）

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

4. 安装mysql

yum localinstall mysql80-community-release-el7-3.noarch.rpm
yum install mysql-community-server

5.启动 

systemctl start mysqld

查看初始密码
cat /var/log/mysqld.log | grep password

登录>>输入密码
mysql -uroot -p

 

6. 修改密码

set global validate_password.policy=0;
set global validate_password.length=1;
ALTER USER "root"@"localhost" IDENTIFIED  WITH mysql_native_password BY "123456";

--然后退出，重新用新密码123456登录

7.远程登录

use mysql

select host,user from user;

update user set host= '%' where user = 'root';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

FLUSH PRIVILEGES;

重启mysql
systemctl restart mysqld

注意关闭防火墙