tags:

views:

71

answers:

2

Hello Techies,

I have problem to connect remote LAN MYSQL. While try following commands it shows like an error.

mysql -u root -h 192.168.1.15 -p

GRANT ALL test.* TO root'192.168.1.15' IDENTIFIED BY '';

ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.15' (10060)

Thanks in advance

+1  A: 
GRANT ALL ON test.* TO 'root'@'192.168.1.15' IDENTIFIED BY '';
Chris Kloberdanz
having a no password root access on network, kind of scary.
RageZ
I completely agree. I was just using the OP's example.
Chris Kloberdanz
i didnt set password. this is the probelm of firewall now only i solved that problem.Any thanks for reply to help me..
Mayan Alagar Pandi
Ok thanks lot friend. Can you help me how can we edit ferewall to accept/reject incoming and outgoing TCP/IP connection in LAN
Mayan Alagar Pandi
You should probably ask that question on serverfault.com.
Chris Kloberdanz
+2  A: 

You should also check that your MySQL server has been configured to accept remote TCP connections.

In your MySQL configuration file (my.cnf), you need the following at least:

port         = 3306          # Port MySQL listens on
bind-address = 192.168.1.15  # IP address of your server
# skip-networking            # This should be commented out to enable networking

The default in some configurations is for the bind-address to be 127.0.0.1, or to skip networking completely, which means only local or unix socket connections are possible. This is for security reasons.

You can also configure the bind-address to be 0.0.0.0 which means it will bind on all IP addresses on the server.

And lastly, check your firewall configuration to allow port 3306.

Andre Miller