使用yum安装mysql 8.0.17版本
1.安装mysql仓库
yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm
2.安装mysql数据库
yum install mysql-server
3.更改默认插件,使用mysql_native_password
将配置文件的注释取消
vi /etc/my.cnf default-authentication-plugin=mysql_native_password
4.启动mysql服务
systemctl start mysqld
5.使用默认密码登录mysql
#找到默认密码 grep pass /var/log/mysqld.log mysql -u root -p
6.修改默认密码安全级别,可以使用简单的密码
UNINSTALL COMPONENT 'file://component_validate_password';
7.修改密码
alter user root@localhost identified by 'root';
8.创建远程连接用户
create user 'root'@'%' identified by 'root'; 授权用户 grant all privileges on *.* to 'root'@'%'; flush privileges;