From: Claudio Nanni
Date: November 5 2009 8:29pm
Subject: Re: socket '/tmp/mysql.sock' (2)
List-Archive: http://lists.mysql.com/mysql/219274
Message-Id: <4AF33590.3030309@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.nanni@stripped]
> *Sent:* Wednesday, November 04, 2009 2:54 AM
> *To:* Brown, Charles
> *Cc:* mysql@stripped
> *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" <CBrown@stripped
>     <mailto:CBrown@stripped>> wrote:
>
>
>
>     ________________________________________
>     From: Brown, Charles
>     Sent: Tuesday, November 03, 2009 2:54 PM
>     To: Ramsey, Robert L; mysql@stripped
>     <mailto:mysql@stripped>
>     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.
> ********************************************
>