mysql-proxy and users with no localhost permission

[Fernando Urzedo]

Hi all,

I have just installed mysql-proxy 0.8.0 in the same server I run a MySQL 5.0.67, lets call it SERVER A. I am able to start the proxy successfully, providing only the LUA script option and it works fine.

However, I have just noticed that the proxy only accepts connections of remote users that have privileges to access that MySQL instance from localhost . I mean, If I define a user with no privileges when accessing that MySQL from SERVER A, it will not connect to the MySQL via proxy. On the other hand, all users that only had privileges to connect from localhost are now exposed via mysql-proxy's port.

I would like to know if there is something I can do to fix this behaviour. In other words, If I defined a user that can only connects from the same server MySQl is running, this user will not have a chance to connect remotely via mysql-proxy... and If I define a user that is allowed to connect only from remote servers, it will be possible either via mysql-proxy or directly to MySQL port.

Thanks in advance!