RE: Connecting Remotely to MySQL Server

2010-06-08 Thread Qu, Gang
: 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

Re: Connecting Remotely to MySQL Server

2010-06-07 Thread Andy
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 'a

RE: Connecting Remotely to MySQL Server

2010-06-07 Thread Qu, Gang
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: