navicat can't connect to MySQL server on 10038
程序员文章站
2022-05-01 21:51:37
...
恢复了下阿里云快照和mysql数据,然后远程数据库连接不上了,本地可以
报错 can’t connect to MySQL server on 10038
看了下3306端口是开放的,然后数据库的权限也是有的
符:数据库修改权限命令
grant all privileges on . to ‘root’@’%’ identified by '密码;
flush privileges;
查看是有监听的,但是公网访问3306端口不通。iptables 有个DROP规则
删除DROP之后可以访问到这个端口
执行命令
iptables -D INPUT 6
至此能ping通3306端口了(cmd命令telnet IP 3306),navicat远程也能连接成功了
推荐阅读
-
Linux登录MySQL时出现 Can't connect to local MySQL server through socket '/tmp/mysql.sock'解决方法
-
连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
-
MYSQL ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.10.210' (111) 解决方法
-
MySQL连接错误:Can't connect to MySQL server on'localhost' (10055)
-
MySQL错误 ERROR 2002 (HY000): Can't connect to local MySQL server through socket 的解决办法
-
windows 连接 linux 上的mysql出现Can't connect to; is not allowed to connect;Access denied for user
-
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)解决办法
-
Can't connect to local MySQL server through socket
-
Can't connect to MySQL server on 'localhost' (10061)问题描述及解决办法
-
MySQL问题记录——2003-Can't connect to MySQL server on 'localhost'(10038)