mysql.sock

[drewshen]

drewshen wrote:
> 
> 
> 
> Vitali Malicky wrote:
>> 
>> 
>> ----- Original Message -----
>> From: "drewshen" <drewsheneman at gmail.com>
>> To: <freebsd-database at freebsd.org>
>> Sent: Monday, March 05, 2007 7:04 PM
>> Subject: Re: mysql.sock
>> 
>> 
>> 
>> 
>> 
>> Momchil Ivanov wrote:
>>>
>>> На 2.3.2007 17:55 drewshen пише:
>>>> I installed  mysql through ports on freebsd 6.1.  i started the daemon,
>>>> and
>>>> mysql starts.  however when i try "mysql" i get
>>>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>>>> '/tmp/mysql.sock'
>>>>
>>>> i looked this up on the mysql page and did find much help.  first i
>>>> tried
>>>>
>>>> shell> chmod +t /tmp
>>>>
>>>> to protect tmp.  that didnt solve it, so i tried to point my sock file
>>>> to
>>>> another directory in /etc/my.cnf.  i got the same error message, even
>>>> with
>>>> the new directory.  does anyone know where my problem lies? thanks!
>>>
>>> "What do you see in your mysql error log file?"
>>>
>>> my error log shows no record of the "mysql.sock" error message. my
>>> latest
>>> record in it was when i restarted mysql.  i tried "ps -ef | grep mysql"
>>> and the only result was my search. however when i started mysql it said
>>> it
>>> was starting.
>>>
>> 
>> "weird...
>> will you please send your my.cnf here?
>> also I wouldn't mind to see your build options."
>> 
>> 
>> "I created my.cnf in order to try to redirect where mysql.sock was
>> created.  When this did not work I deleted it.  I did not use any
>> customized build options either, I just used the updated ports collection
>> in freebsd 6.1. and did a "make install clean." Is there any way I can
>> allow mysql to create this socket file so it will work properly?"
>> 
>> I tried mysqld_safe:
>> 
>> # mysqld_safe
>> Starting mysqld daemon with databases from /var/db/mysql
>> STOPPING server from pid file /var/db/mysql/hostname.com.pid
>> 070312 10:29:29  mysqld ended
>> 
>> i was running as root when i tried this
>> 
>> i also tried again to set up a different location to create mysql.sock:
>> 
>> i put these lines in my.cnf:
>> 
>> [mysqld] 
>> socket=/usr/local/etc      
>>  
>> [client]
>> socket=/usr/local/etc 
>> 
>> and tried to start mysql:
>> 
>> # mysql
>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>> '/usr/local/etc' (38)
>> # 
>> 
>> i tried mysqld_safe again:
>> 
>> # mysqld_safe
>> Starting mysqld daemon with databases from /var/db/mysql
>> rm: /usr/local/etc: is a directory
>> STOPPING server from pid file /var/db/mysql/hostname.com.pid
>> 070312 10:39:46  mysqld ended
>> 
>> 
>>> --
>>> This correspondence is strictly confidential. Any screening, filtering
>>> and/or production for the purpose of public or otherwise disclosure is
>>> forbidden without written permission by the author signed above. If you
>>> are
>>> not the intended recipient, please immediately notify the sender and
>>> permanently delete any copies
>>>
>>> PGP KeyID: 0x3118168B
>>> Keyserver: pgp.mit.edu
>>> Key fingerprint BB50 2983 0714 36DC D02E  158A E03D 56DA 3118 168B
>>>
>>>
>>>
>> 
>> --
>> View this message in context:
>> http://www.nabble.com/mysql.sock-tf3334648.html#a9315636
>> Sent from the freebsd-database mailing list archive at Nabble.com.
>> 
>> _______________________________________________
>> freebsd-database at freebsd.org mailing list
>> http://lists.freebsd.org/mailman/listinfo/freebsd-database
>> To unsubscribe, send any mail to
>> "freebsd-database-unsubscribe at freebsd.org"
>> 
>> 
>> 
>> _______________________________________________
>> freebsd-database at freebsd.org mailing list
>> http://lists.freebsd.org/mailman/listinfo/freebsd-database
>> To unsubscribe, send any mail to
>> "freebsd-database-unsubscribe at freebsd.org"
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/mysql.sock-tf3334648.html#a9436795
Sent from the freebsd-database mailing list archive at Nabble.com.