mysql.sock

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!
-- 
View this message in context: http://www.nabble.com/mysql.sock-tf3334648.html#a9273118

Sent from the freebsd-database mailing list archive at
Nabble.com.

_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

?? 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?

-- 
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

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.   
> 
> -- 
> 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-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

----- Original Message -----
From: "drewshen" <drewshenemangmail.com>
To: <freebsd-databasefreebsd.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.


> --
> 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-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"



_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

Vitali Malicky wrote:
> 
> 
> ----- Original Message -----
> From: "drewshen" <drewshenemangmail.com>
> To: <freebsd-databasefreebsd.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?
> 
> 
>> --
>> 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-databasefreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
> To unsubscribe, send any mail to
> "freebsd-database-unsubscribefreebsd.org"
> 
> 
> 
> _______________________________________________
> freebsd-databasefreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
> To unsubscribe, send any mail to
> "freebsd-database-unsubscribefreebsd.org"
> 
> 

-- 
View this message in context: http://www.nabble.com/mysql.sock-tf3334648.html#a9397995

Sent from the freebsd-database mailing list archive at
Nabble.com.

_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

drewshen wrote:
> 
> 
> 
> Vitali Malicky wrote:
>> 
>> 
>> ----- Original Message -----
>> From: "drewshen" <drewshenemangmail.com>
>> To: <freebsd-databasefreebsd.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-databasefreebsd.org mailing list
>> http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
>> To unsubscribe, send any mail to
>> "freebsd-database-unsubscribefreebsd.org"
>> 
>> 
>> 
>> _______________________________________________
>> freebsd-databasefreebsd.org mailing list
>> http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
>> To unsubscribe, send any mail to
>> "freebsd-database-unsubscribefreebsd.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.

_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"