Navicat连接Linux下MySQL

1.进入数据库

mysql -u root -p

2.给其他电脑赋予权限

1.use mysql;
2.GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

1233456 是MySQL密码

此时：

mysql> SELECT user,host FROM mysql.user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| root          | %         |
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+
4 rows in set (0.00 sec)

3.刷新

3.FLUSH PRIVILEGES;
4.exit;

4.查看防火墙状态

systemctl status firewalld.service

开启mysql的3306端口

firewall-cmd --zone=public --add-port=27017/tcp --permanent
//记得重新加载配置规则，即在该指令后面在执行firewall-cmd --reload

或

关闭防火墙

systemctl stop firewalld.service

在查看防火墙的状态：disavtive（dead），表示关闭了（重启之后还会打开）。

Navicat连接MySQL