The default did have the "skip-networking" on. I commented that out as you advised, and it worked like a Charm!! I'm pretty excited to be able to have that working now. I really really appreciate the prompt reply and the consideration that you both took in your replies.
Thanks again.
Aaron-
On Jan 10, 2004, at 3:20 PM, Johannes Franken wrote:
* Aaron Gerber <[EMAIL PROTECTED]> [2004-01-10 21:33 +0100]:Locally, I can connect to the MySQL server [...] but I can't connect if I put in the IP address (locally or remotely)
Maybe mysqld is configured to listen on its unix domain socket only? This is the default for Debian.
Remove the line 'skip-networking' from /etc/mysql/my.cnf, type "/etc/init.d/mysql restart" and try connecting to the IP address again.
On Jan 10, 2004, at 3:30 PM, Roger Baklund wrote:
Note that there are two ways to connect to the mysql server: using sockets
(or named pipes on windows) or using TCP/IP. If you provide "-h
hostname-or-ip-address" a TCP/IP connection is used, if you provide "-h
localhost" or no -h parameter, a unix socket is used.
You are not running the server with "--skip-networking", are you? If you
are, TCP/IP support is disabled. Have you configured the server to use a
non-standard port (different from 3306)? In that case, you must provide port
number when starting the client:
mysql -h xxx.168.xxx.xxx --port=3307 -u xxxxxxx -p
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
