Connecting Remotely to MySQL Server

--0016363b8f9827ba92048875caeb
Content-Type: text/plain; charset=ISO-8859-1

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 -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

--0016363b8f9827ba92048875caeb--

RE: Connecting Remotely to MySQL Server

Make sure the port is open from the db server. you can test it using "teln=
et server 3306(if that's what you use)". If not, have your network admin o=
pen the port for you.


-----Original Message-----
From: listanand@gmail.com [mailto:listanand@gmail.com]=20
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 boxe=
s
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 -u andy -p

After I do this, it asks for my password, and after I enter it, it just sit=
s
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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Connecting Remotely to MySQL Server

--00c09ffb4eb37d6d86048877c5e8
Content-Type: text/plain; charset=ISO-8859-1

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 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: listanand@gmail.com [mailto:listanand@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 -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
>

--00c09ffb4eb37d6d86048877c5e8--

RE: Connecting Remotely to MySQL Server

--_000_BC56FAA8C9D07244838BAB8DD6B4E5CC0456E61002EXCCRVS1mic or_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 sta=
tement. I think you need a DNS entry for your first question, not so sure =
about the question.

From: Andy [mailto:listanand@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 i=
ntranet 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 fac=
t 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 ngQu@quickenloans.com>> wrote:
Make sure the port is open from the db server. you can test it using "teln=
et server 3306(if that's what you use)". If not, have your network admin o=
pen the port for you.


-----Original Message-----
From: listanand@gmail.com [mailto:listanand@gma=
il.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 boxe=
s
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 -u andy -p

After I do this, it asks for my password, and after I enter it, it just sit=
s
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


--_000_BC56FAA8C9D07244838BAB8DD6B4E5CC0456E61002EXCCRVS1mic or_--