客户端无法通过4040端口连接到mysql proxy
答案:2 悬赏:10 手机版
解决时间 2021-11-20 01:44
- 提问者网友:寂寞梧桐
- 2021-11-19 13:42
客户端无法通过4040端口连接到mysql proxy
最佳答案
- 五星知识达人网友:神也偏爱
- 2021-11-19 15:06
不能连接mysql服务器的原因
总结下来也就以下几种
检查你的PHP.ini 是否已经开启了对mysql的支持,如果你是WINDOWS系统的
;extension=php_mbstring.dll (这不选一般用PHPMYADMIN会出红色提示,故必选)
;extension=php_mysql.dll (这个是用来支持MYSQL的,要支持MYSQL必选)
看看前面的;是不是已经去掉
LINUX可能要稍微麻烦一些,因为在你编译PHP的时候./configure prix= 后面已经定义好了
另外一种情况,就是检查你输入的帐号密码,是否错误
还有一种情况,比如root,在你安装MYSQL的时候,会询问你支不支持远程连接
如果你当时选的不支持,那么你远程用root连接mysql,一样会提示错误
大概就这么情况,希望对你有所帮助
总结下来也就以下几种
检查你的PHP.ini 是否已经开启了对mysql的支持,如果你是WINDOWS系统的
;extension=php_mbstring.dll (这不选一般用PHPMYADMIN会出红色提示,故必选)
;extension=php_mysql.dll (这个是用来支持MYSQL的,要支持MYSQL必选)
看看前面的;是不是已经去掉
LINUX可能要稍微麻烦一些,因为在你编译PHP的时候./configure prix= 后面已经定义好了
另外一种情况,就是检查你输入的帐号密码,是否错误
还有一种情况,比如root,在你安装MYSQL的时候,会询问你支不支持远程连接
如果你当时选的不支持,那么你远程用root连接mysql,一样会提示错误
大概就这么情况,希望对你有所帮助
全部回答
- 1楼网友:夜风逐马
- 2021-11-19 15:26
我也碰到类似问题,不过问题不太一样
我是刚开始能连上,连接一多就间歇性出问题
一下能连上,一下报错,非常有规律
2010-11-30 23:04:06: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:06: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:06: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:07: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:07: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:08: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:09: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:09: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:09: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:10: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:10: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:11: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:12: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:12: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:12: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:13: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:13: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:14: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:15: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:15: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:15: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:16: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:16: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:17: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
我是刚开始能连上,连接一多就间歇性出问题
一下能连上,一下报错,非常有规律
2010-11-30 23:04:06: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:06: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:06: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:07: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:07: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:08: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:09: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:09: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:09: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:10: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:10: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:11: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:12: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:12: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:12: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:13: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:13: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:14: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:15: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:15: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:15: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-11-30 23:04:16: (debug) abs wait-for-event::done usec= 0
2010-11-30 23:04:16: (debug) abs lua-exec::done usec= 0
2010-11-30 23:04:17: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯