Cannot connect to local mySQL server through socket error (111)
I have the exact problem. I wonder why the file size is 0 of the file mysql.sock? I >Hi! > >Socket file specified is : /var/lib/mysql/mysql.sock >which on my system%2
Re: Cannot connect to local mySQL server through socket error (111)
Chuang Keng Chee wrote: > > Hi! > > Socket file specified is : /var/lib/mysql/mysql.sock > which on my system has a filesize of zero. I'm running a Red Hat > 7.0, Kernel 2.2.16-22smp > which I installed with MySQL (ie, MySQL wasn't installed separately from > source files.) > > I've got three copies of mysqld running when I do a ps (so, no problems > with linuxthreads there.) > > In the /var/lib/mysql directory, there's an error file that said it > could not create/write the > mysql.pid file into /var/run. > > Since the /var/run directory is owned by root and mysql did not have > write permissions, I > gave write permissions to the others group. Still no luck. > > Is there some other configuration I need to do to get it to work ? > Don't see why something > installed out of the box should be having such problems. > > Thanks for any help. > > P.S. Searched through the lists archives, but only got back garbage > from the mailing list on > this problem. > If you installed it out of the Red Hat box, then that is the problem. Go to redhat.com and get the fixxed rpm, or fix all your permissions manually. I'll bet this question has been covered 100 times. I'm sure it is in the archives. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot connect to local mySQL server through socket error (111)
Hi! Socket file specified is : /var/lib/mysql/mysql.sock which on my system has a filesize of zero. I'm running a Red Hat 7.0, Kernel 2.2.16-22smp which I installed with MySQL (ie, MySQL wasn't installed separately from source files.) I've got three copies of mysqld running when I do a ps (so, no problems with linuxthreads there.) In the /var/lib/mysql directory, there's an error file that said it could not create/write the mysql.pid file into /var/run. Since the /var/run directory is owned by root and mysql did not have write permissions, I gave write permissions to the others group. Still no luck. Is there some other configuration I need to do to get it to work ? Don't see why something installed out of the box should be having such problems. Thanks for any help. P.S. Searched through the lists archives, but only got back garbage from the mailing list on this problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
