Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
567 views
in Technique[技术] by (71.8m points)

Navicat 连接远程mysql数据库 报错1129

台式机使用Navicat Premium 12连接mysql数据库的时候,报这个错误,本人的笔记本或者他人的电脑连接这个数据库没有任何问题,再就是提示报的Host的ip不是本人台式机的ip地址,请教各位大神,这种情况该怎么办?
image.png


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

连接数太多了,放大一下服务器连接数吧,
修改配置文件 my.ini /my.cnf

max_connections = 1000

mysqladmin flush-hosts -u root -ppassword


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

56.6k users

...