Hi Charles,
the socket is created either in the default location or in the location
specified in the 'my.cnf' configuration file under the [mysqld] section,
you can have different 'my.cnf' files in the system in different default
locations that are read in a cascading style sheet fashion (for the
locations look in the manual),
you can also specify one and only configuration file using the flag
--defaults-file=/path/to/my.cnf
Keep in mind that the socket file connection method works only on the
local system and only on unix/linux o.s.
So to not have the need to specify anything when using the 'mysql'
client program just specify the same path for the socket file under the
[mysql] and [mysqld] section of the 'my.cnf'.
Hope this helps
Claudio
Brown, Charles wrote:
Claudio, It worked but here is a follow up question. Is this a
circumvention or permanent fix. Why is it pointing to a
/tmp/Mysql.sock when one socket exists in /var/lib/Mysql
*From:* Claudio Nanni [mailto:claudio.na...@gmail.com]
*Sent:* Wednesday, November 04, 2009 2:54 AM
*To:* Brown, Charles
*Cc:* mysql@lists.mysql.com
*Subject:* Re: RE: socket '/tmp/mysql.sock' (2)
Hi Charles,
Try this:
mysql -uxxxx -pxxxx -h127.0.0.1 -P3306
to force tcp instead of socket
Let me know!
Cheers
Claudio
On Nov 4, 2009 4:34 AM, "Brown, Charles" <cbr...@bmi.com
<mailto:cbr...@bmi.com>> wrote:
________________________________________
From: Brown, Charles
Sent: Tuesday, November 03, 2009 2:54 PM
To: Ramsey, Robert L; mysql@lists.mysql.com
<mailto:mysql@lists.mysql.com>
Subject: socket '/tmp/mysql.sock' (2)
Hello All, I desperately need your help. I migrated from version
5.0.27 To version 5.0.77 Here ...
********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.
If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.
Thank you.
********************************************
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
