centos7---mysql8.0安装及远程连接权限设置

1、下载yum库

https://dev.mysql.com/downloads/repo/yum/

2、安装yum库

sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm

3、选择安装版本

sudo yum-config-manager --disable mysql80-community  # 禁用8.0版本，默认时8.0

sudo yum-config-manager --enable mysql57-community  # 启用5.7版本。

 4、安装mysql

sudo yum install mysql-community-server

5、启动mysql

sudo systemctl start mysqld.service

6、查看mysql初始化密码

sudo grep 'temporary password' /var/log/mysqld.log

2019-05-06T05:30:14.429717Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: WefwqWfjU2&)

7、登录

mysql -u root -p

密码就是6看到的密码 WefwqWfjU2&)

8、修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

9、远程登陆设置

use mysql;

select host, user, authe