I had to puzzle out the socket location also. For me, what worked was
mysql> SHOW VARIABLES;
One of the variables had the socket location of the server.
You might try
mysql> SHOW VARIABLES LIKE 'socket';
P. 932 of DuBois, _MySQL_ (2nd ed) claims that the variable named
socket
is "The pathname to the UNIX domain socket, or the name of the named pipe
under Windows."
Cheers,
sjfromm
----- Original Message -----
From: "Martin" <mgainty@stripped>
To: "Carl Shockley" <carls@stripped>; <mysql@stripped>
Sent: Friday, April 18, 2003 1:31 PM
Subject: Re: mysqlbug
> I know on my box I need the C:/my.cnf which contains these entries:
>
> # The MySQL server
> [mysqld]
> basedir=G:/WindowsMySQL
> datadir=G:/WindowsMySQL/data
>
> port = 3306
> socket = /tmp/mysql.sock
>
> what does your my.cnf say?
> Martin
> ----- Original Message -----
> From: "Carl Shockley" <carls@stripped>
> To: <mysql@stripped>
> Sent: Friday, April 18, 2003 9:13 AM
> Subject: mysqlbug
>
>
> > I'm trying to install mysql on a linux test box but when I try and start
> > mysql I get the following error message
> >
> > "can't connect to local MySQL server through socket
> > '/var/lib/mysql/mysql.sock' (111)
> >
> > Any ideas as to what this could be, and I have already ran
> mysql_install_db.
> > Could there be anything else I'm missing?
> >
> >
> > Thx
> >
> > Carl Shockley
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
