Fred Aswad wrote:
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
You are asking for a password.
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;
You forgot to set the password. You forgot "identified by 'thepassword'"
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]
