RE: Connecting Remotely to MySQL Server
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.commailto: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.commailto:listan...@gmail.com [mailto:listan...@gmail.commailto:listan...@gmail.com] Sent: Monday, June 07, 2010 3:37 PM To: mysql@lists.mysql.commailto: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
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
RE: Connecting Remotely to MySQL Server
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] Sent: Monday, June 07, 2010 3:37 PM To: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 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] Sent: Monday, June 07, 2010 3:37 PM To: 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
Error: Connecting remotely to mysql server
hi i installed mysql on redhat 7.1 .It's working fine for localhost. i made the user entry in mysql-user table as '192.168.1.20','test','test','Y','. and try to connect from 192.168.1.20(linux-system) but it is giving error as Error: host '192.168.1.20' is not allowed to connect to this MySql server. is there any other setting needed for that plz help me thanks in advance *NEW* over 2200 active jobs at Yahoo! Careers *NEW* Visit http://in.careers.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php