centos8安装MySQL8.0并远程登陆

centos8安装MySQL8.0并远程登陆

1，安装命令：sudo dnf install @mysql

2，设置开机自启：sudo systemctl enable --now mysqld

3，查询MySQL运行状况：sudo systemctl status mysqld.service

Active:active (running) 代表安装成功

4，登陆mysql：MySQL -h localhost -P3306(默认) -u root -p password

更改user表进行远程登陆设置

5, 查看user表：mysql> show databases;

    使用user表 ：mysql> use mysql;

    查看mysql库下的user表：mysql> select user,authentication_string,host from user;

    更改'host' ： mysql> update user set host = '%' where user = 'root';

    更新：mysql> flush privileges;

6，更改防火墙，添加端口：firewall-cmd --zone=public --add-port=3306/tcp --permanent

     更新防火墙：firewall-cmd --reload