I have a client on linux and the mysql server on windows
I wanted to connect to mysql remotely 2 computers can ping each other without any problem in mysql server I set the permission correctly so the specified client is allowed to connect
WIN IP: 192.168.1.2
Linux IP:192.168.1.3
in windows system:
GRANT ALL ON *.* TO 'parsa'@'192.168.1.3' IDENTIFIED BY 'parsa';
flush all privileges;
in my linux,in my.cnf I wrote this line in mysqld
section
bind-address=192.168.1.2
skip-networking
was commented and I didn't change it
I restarted the mysql
when I use
telnet 192.168.1.2 3306
telnet:connect to address 192.168.1.2:Connection timed out
and using this command:
mysql -h 192.168.1.2 -u parsa -p parsa
Error 2003:can't connect to mysql server on 192.168.1.2
The firewalls
in both sides are disabled what should I do?
command:net stats srv
Statistics since 2/29/2012 4:52:22 PM
Sessions accepted 1
Sessions timed-out 0
Sessions errored-out 0
Kilobytes sent 0
Kilobytes received 0
Mean response time (msec) 0
System errors 0
Permission violations 0
Password violations 0
Files accessed 0
Communication devices accessed 0
Print jobs spooled 0
Times buffers exhausted
Big buffers 0
Request buffers 0
The command completed successfully.
Connection timed out
can mean two things:To see how busy the server is, use
uptime
. Load average > 10 means "busy". Load average < 1 means "idle".If the server is idle, check for the firewall settings on the server, then check the client.