linux安装mysql连接navicat需要步骤

1.进入数据库

mysql -uroot -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.刷新

1.FLUSH PRIVILEGES;

2.exit;

4.查看防火墙状态

systemctl status firewalld.service

开启mysql的3306端口

或者用ss查看端口号

1. firewall-cmd --zone=public --add-port=27017/tcp --permanent

2. //记得重新加载配置规则，即在该指令后面在执行firewall-cmd --reload

或

关闭防火墙

systemctl stop firewalld.service