From: Aaron Gerber (gerberadtrvnet.net)
Date: Sat Jan 10 2004 - 16:59:16 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Roger and Johannes,

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 <gerberadtrvnet.net> [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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]