解决Navicat无法连接mysql数据库常见问题
作者：热心网友 | 发布时间： | 更新时间：
相关软件
data-postsbox="{"id":3032,"title":"Navicat Premium 15最新企业破解版下载","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":3110,"comment_count":5,"category":"software","is_forum_post":false}">{"id":3032,"title":"Navicat Premium 15最新企业破解版下载","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":3110,"comment_count":5,"category":"software","is_forum_post":false}
data-postsbox="{"id":900,"title":"Navicat for MySql 11.1.13企业版破解版","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":2056,"comment_count":2,"category":"software","is_forum_post":false}">{"id":900,"title":"Navicat for MySql 11.1.13企业版破解版","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":2056,"comment_count":2,"category":"software","is_forum_post":false}
相关阅读
data-postsbox="{"id":3797,"title":"source导入sql文件出错ASCII '\\0' appeared in the statement","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":3584,"comment_count":0,"category":"cybersecurity","is_forum_post":false}">{"id":3797,"title":"source导入sql文件出错ASCII '\\0' appeared in the statement","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":3584,"comment_count":0,"category":"cybersecurity","is_forum_post":false}
data-postsbox="{"id":899,"title":"Windows mysql8.0忘记密码如何解决","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":1142,"comment_count":0,"category":"cybersecurity","is_forum_post":false}">{"id":899,"title":"Windows mysql8.0忘记密码如何解决","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":1142,"comment_count":0,"category":"cybersecurity","is_forum_post":false}
data-postsbox="{"id":203,"title":"MySQL导入数据502及MySQL said: #1709解决方法","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":1862,"comment_count":0,"category":"cybersecurity","is_forum_post":false}">{"id":203,"title":"MySQL导入数据502及MySQL said: #1709解决方法","author":"FancyPig","author_id":1,"cover_image":"","cover_video":"","views":1862,"comment_count":0,"category":"cybersecurity","is_forum_post":false}
报错信息与解决方案
Can't connect to MySql server on 'localhost'(10061)错误
这里通常是数据库服务就没有启动！
去检查下自己的mysql是不是挂了
我们这里是宝塔面板，启动了即可
2003-Can’t connect to MySQL server on ‘XXX.XX.XX.XX’（10060）
这里通常是默认的3306端口没有打开，当然如果你的端口进行了自定义修改，需要在连接时也进行相应的修改
我们这里是用的宝塔面板，这里是安全中3306端口没有放行，如果你放行了依旧没有效果，还有一种可能是云服务器上的安全组端口没有放行导致的
1130 - Host 'xxx' is not allowed to connect to this MySQL server错误
这里通常是mysql数据库中设置的问题，下面是简要的解决步骤
- 连接mysql，然后输入root密码
mysql -u root -p- 查看mysql中全部的数据库
show databases;- 进入mysql数据库
use mysql;- 查看mysql数据库中所有的表
show tables;- 查看user表中的数据
select Host, User,Password from user;- 修改user表中的Host
update user set Host=’%’ where User=‘root’;- 刷新数据库
flush privileges;