 | | | remote connection | remote connection 2007-09-16 - By Bonnett, John
Back
When connecting to a remote MySQL server a number of things need to be
correct.
Can you reach the machine where the server is?
You can check this from a command prompt using the command
ping 192.168.0.180
This should show you if your packets can reach that machine.
Does the remote machine have MySQL running?
You really need to check that MYSQL is running, usually as a service
under Windows, on the remote machine.
I assume you know that is correct.
Can you access the MySQL port on the remote machine?
As well as being able to access the IP address, the MySQL server listens
for commands on a particular port, usually 3306. Your requests need to
be addressed to that port and there must be nothing in between, like a
firewall, that is blocking access to that port. For instance Windows
firewall (or ZoneAlarm etc.) running on the server might block access to
that port. You might need to reconfigure the firewall to allow that port
to be accessed. I believe you can check this by a command like
telnet 192.168.0.180:3306
Although I have never tried that. On a LAN you probably do not need to
be concerned about a hardware firewall, but one of those might block
your access too, and need to be reconfigured.
Assuming all the above is OK, I would next try to access the server
using the mysql command line tool. There are example in the manual about
how to use that but something like
mysql -uroot -p -h192.168.0.180 mysql
Which will prompt for the root password, should get you connected. You
of course can use another user name if one is set up on the server.
It is only when I have got this far that I would try using MyODBC to
connect to the server. If you set up the connection in ODBC in the
Control Panel in Windows you can test the connection there.
Hope that gives you some ideas about what to check.
John Bonnett
-- --Original Message-- --
From: Jess Balint [mailto:jbalint@(protected)]
Sent: Wednesday, 12 September 2007 4:18 AM
To: Leppin Tan
Cc: myodbc@(protected)
Subject: Re: remote connection
Pat,
Please review the troubleshooting information regarding this problem:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
The most common solutions include removing bind-address= and
skip-networking from my.cnf and removing any firewall rules blocking
port 3306.
Jess
On Tue, Sep 11, 2007 at 08:18:03AM +0000, Leppin Tan wrote:
> To whom it may concern
>
> hi there! just like to ask for some assistant coz here's my problem, i
am trying to access MYSQL server 5.0.0(in computer A) using another
computer(computer B) via LAN. i followed the procedure in your manual on
the 23.1.9.6 part (establishing a Remote Connection to System A from
System B) and 23.1.9.2 (configuring a MYODBC DSN on Windows) but i
received an error message of "[MySQL][ODBC 3.51 Driver]Can't connect to
MySQL server on '192.168.0.180' (10060)".
>
> What does (10060) means? if also possible, can you teach me what are
other thing i need to consider before i can access the data stored in
the MYSQL server 5.0.0(in computer A) using (computer B). Thanks a lot
for the help in advance.
>
>
> Pat
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)
|
|
|