If you only allow local connection, your setup should works, otherwise, you need to specify from which host you allow the connection in your grant statement. I think you need a DNS entry for your first question, not so sure about the question.
From: Andy [mailto:listan...@gmail.com] Sent: Monday, June 07, 2010 5:58 PM To: Qu, Gang Cc: mysql@lists.mysql.com Subject: Re: Connecting Remotely to MySQL Server OK so I managed to open 3306. Now when I connect using 127.0.0.1 from the intranet box it works, but when I connect using it's IP it's still the same situation :( And now when I connect remotely (from my front end which is accessible via WWW), it says "ERROR 1045 (28000): Access denied for user 'andy'@'frontend.internal' (using password: YES)". Does it have something to do with the fact that 'andy' in the mysql user tables is only authorized to connect from 'localhost'? How do I fix this problem. Thank you very much. Andy On Mon, Jun 7, 2010 at 3:41 PM, Qu, Gang <gan...@quickenloans.com<mailto:gan...@quickenloans.com>> wrote: Make sure the port is open from the db server. you can test it using "telnet server 3306(if that's what you use)". If not, have your network admin open the port for you. -----Original Message----- From: listan...@gmail.com<mailto:listan...@gmail.com> [mailto:listan...@gmail.com<mailto:listan...@gmail.com>] Sent: Monday, June 07, 2010 3:37 PM To: mysql@lists.mysql.com<mailto:mysql@lists.mysql.com> Subject: Connecting Remotely to MySQL Server Hello all, New to MySQL and still exploring. I have MySQL installed on one of the boxes on the intranet (on which I am not the root) and am trying to connect to it remotely via a box (that can be see from the "external world"). Unfortunately it does not seem to be working. Here's what I did from the shell: my sql -h <IP_OF_INTRANET_BOX> -u andy -p After I do this, it asks for my password, and after I enter it, it just sits there doing nothing. I am however able to login using my credentials from the intranet box directly. However when from the intranet box, I try to login using the exact command above, it's exactly the same situation - it just sits there after I enter the password. Any suggestions? Thanks. Andy
