I've got 2 sites. 1) server : mysqld 4.0.14 standard from mysql.com on linux 2) client : windows 2000 whith mysqlcc 0.9.2 beta and myodbc 3.51.6
Both have dynamic IPs.
The server listens on e.g. server.dyndns.org with ssh port open. In reality it's IP is something like dialin-a-b-c-d.some-isp.net.
The client is e.g. client.dyndns.org with putty as ssh-client. In reality it's IP is again something like x-y-z.another-isp.com.
Client does ssh into server and ssh-forwards server's mysql to 127.0.0.1:3306.
That works.
If I try to connect with MySQLcc from client --> server. MySQL denies access for: dialin-a-b-c-d.some-isp.net ! That's the server's real IP not the origine of the request, client.
Client gets access when I either put 'dialin-a-b-c-d.some-isp.net' into the privileges or '%'.
The address is dynamic so it had to be updated on every ip-up event.
And '%' is no good either since it would weaken mysql's security.
1) Why gets such a remote request transcribed to a request of the server's external address ?
2) How can I have mysql check for client.dyndns.org ?
Thanks Andreas
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
