Date: Mon, 12 Mar 2007 08:32:18 -0700 (PDT) From: drewshen <drewsheneman@gmail.com> To: freebsd-database@freebsd.org Subject: Re: mysql.sock Message-ID: <9436795.post@talk.nabble.com> In-Reply-To: <9397995.post@talk.nabble.com> References: <9273118.post@talk.nabble.com> <200703041906.59868.idiotbg@gmail.com> <9315636.post@talk.nabble.com> <106801c75fd3$7d6d9420$2401010a@zone3000.net> <9397995.post@talk.nabble.com>
next in thread | previous in thread | raw e-mail | index | archive | help
drewshen wrote: >=20 >=20 >=20 > Vitali Malicky wrote: >>=20 >>=20 >> ----- Original Message ----- >> From: "drewshen" <drewsheneman@gmail.com> >> To: <freebsd-database@freebsd.org> >> Sent: Monday, March 05, 2007 7:04 PM >> Subject: Re: mysql.sock >>=20 >>=20 >>=20 >>=20 >>=20 >> Momchil Ivanov wrote: >>> >>> =D0=9D=D0=B0 2.3.2007 17:55 drewshen =D0=BF=D0=B8=D1=88=D0=B5: >>>> 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. >>> >>=20 >> "weird... >> will you please send your my.cnf here? >> also I wouldn't mind to see your build options." >>=20 >>=20 >> "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 collectio= n >> 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?" >>=20 >> I tried mysqld_safe: >>=20 >> # 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 >>=20 >> i was running as root when i tried this >>=20 >> i also tried again to set up a different location to create mysql.sock: >>=20 >> i put these lines in my.cnf: >>=20 >> [mysqld]=20 >> socket=3D/usr/local/etc =20 >> =20 >> [client] >> socket=3D/usr/local/etc=20 >>=20 >> and tried to start mysql: >>=20 >> # mysql >> ERROR 2002 (HY000): Can't connect to local MySQL server through socket >> '/usr/local/etc' (38) >> #=20 >>=20 >> i tried mysqld_safe again: >>=20 >> # 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 >>=20 >>=20 >>> -- >>> 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 >>> >>> >>> >>=20 >> -- >> 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. >>=20 >> _______________________________________________ >> freebsd-database@freebsd.org mailing list >> http://lists.freebsd.org/mailman/listinfo/freebsd-database >> To unsubscribe, send any mail to >> "freebsd-database-unsubscribe@freebsd.org" >>=20 >>=20 >>=20 >> _______________________________________________ >> freebsd-database@freebsd.org mailing list >> http://lists.freebsd.org/mailman/listinfo/freebsd-database >> To unsubscribe, send any mail to >> "freebsd-database-unsubscribe@freebsd.org" >>=20 >>=20 >=20 >=20 --=20 View this message in context: http://www.nabble.com/mysql.sock-tf3334648.ht= ml#a9436795 Sent from the freebsd-database mailing list archive at Nabble.com.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?9436795.post>