Is each machine behind a firewall or are both machines behind the same firewall? If the firewalls are different you will need to connect to the firewall address and not the lan address. You will also need to ensure that Port 3306 is open in the firewall.
-----Original Message----- From: Fred Aswad To: [EMAIL PROTECTED] Sent: 6/2/04 12:45 PM Subject: Help With Remotely Connecting to MySQL Database I need some help connecting to my database remotely, I would really appreciate any input. Setup: MySQL Server: OS: Linux - Debian MySQL version: 4.0.18 Internal IP: 192.168.1.101 Remote Access PC: OS: Windows XP MySQL: 4.0.20 Internal IP: 192.168.1.100 I am trying to connect from 192.168.1.100 to 192.168.1.101. The computers are connected via a Linksys router. I type the following line from a cmd prompt in Windows XP: mysql -h 192.168.1.101 -u user -p and get the following error: "ERROR 2003: Can't connect to MySQL server on '192.168.1.101' (10061)" Mysqld is running on the MySQL server. From the server I can localy access the database by typing: mysql -u user at the bash, without any problems. I have done the following for 'user' GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.100' WITH GRANT OPTIONS; This was successfully taken into the user table of the mysql db. (select * from user, shows the entry). I have also tried : GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTIONS; I am not sure where to go from here. I get a feeling there hosts.allow file in /etc/ on the linux machine may have something to do with it. I have addded the following in that file: mysqld : ALL : ALLOW mysqld-max : ALL : ALLOW I did not change the default port of 3306. I assume mysqld automatically opens up the port and begins listening for connections right? Thanks for any help!! Fred Aswad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
