mysql proxy无法连接_客户端无法通过4040端口连接到mysql proxy

最新推荐文章于 2022-08-01 13:59:08 发布

weixin_34938347

最新推荐文章于 2022-08-01 13:59:08 发布

阅读量538

点赞数 1

文章标签： mysql proxy无法连接

本文链接：https://blog.csdn.net/weixin_34938347/article/details/113288441

版权

最近在用mysqlproxy，理想情况下是这样的：客户端连接mysqlproxy，然后mysqlproxy根据lua脚本把请求分发到下面的两个mysql服务器，这两个mysql服务器互为主从。但设置好之后却无法通过...

最近在用mysql proxy，理想情况下是这样的：客户端连接mysql proxy，然后mysql proxy根据lua脚本把请求分发到下面的两个mysql服务器，这两个mysql服务器互为主从。但设置好之后却无法通过客户端链接到mysql proxy，远程访问的权限已经开了，但客户端提示：

_mysql_exceptions.OperationalError: (1130, "Host '192.168.0.183' is not allowed to connect to this MySQL server")

mysql proxy日志里面看了一下：

2010-11-25 14:52:40: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.

2010-11-25 15:04:23: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.

2010-11-25 15:19:04: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.

2010-11-25 15:19:59: (debug) last message repeated 1 times

2010-11-25 15:19:59: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.

2010-11-25 15:32:06: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.

2010-11-25 16:06:07: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.

2010-11-25 16:41:13: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.

2010-11-25 17:39:14: (debug) last message repeated 1 times

2010-11-25 17:39:14: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.

请高手指点多谢

展开

关注