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