mysql安装

使用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;