cannot Connect to local MYSQL server through socket
../var/lib/mysql/mysql.sock. I've been round the houses with this following the thread but I can't get past this error despite all the chmod and chown modifications, installed MySQL admin and it still won't start. Am I best to chuck it in the bin or uninstall the lot and start again? This is Fedora Core 3 with MySQL 3.23.58-13. Any help gladly appreciated but its not obvious from the web site how to go beyond the chmod and chown fixes. What does the socks file do anyway? Thanks Andrew G Morris ILT Advisor (Technical) JISC RSC West Midlands 01902 824434 07980 982738
Re: cannot Connect to local MYSQL server through socket
Is the MySQL server running and you can not connect? Or are you not able to start the MySQL server? Morris, Andrew wrote: ../var/lib/mysql/mysql.sock. I've been round the houses with this following the thread but I can't get past this error despite all the chmod and chown modifications, installed MySQL admin and it still won't start. Am I best to chuck it in the bin or uninstall the lot and start again? This is Fedora Core 3 with MySQL 3.23.58-13. Any help gladly appreciated but its not obvious from the web site how to go beyond the chmod and chown fixes. What does the socks file do anyway? Thanks Andrew G Morris ILT Advisor (Technical) JISC RSC West Midlands 01902 824434 07980 982738 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot Connect to local MYSQL server through socket
Hello, The mysql sock file is used for Unix Domain Sockets communication. In essence, it is used for interconnection between processes running on the same system. They function just like ordinary-over-the-net sockets. They are just faster for interprocess communication. I am not sure I understand what your problem is with the file, or what chmod/chown have to do with it. Please explain. MarkP On Wed, 24 Nov 2004 12:00:45 -0600, Victor Pendleton [EMAIL PROTECTED] wrote: Is the MySQL server running and you can not connect? Or are you not able to start the MySQL server? Morris, Andrew wrote: ../var/lib/mysql/mysql.sock. I've been round the houses with this following the thread but I can't get past this error despite all the chmod and chown modifications, installed MySQL admin and it still won't start. Am I best to chuck it in the bin or uninstall the lot and start again? This is Fedora Core 3 with MySQL 3.23.58-13. Any help gladly appreciated but its not obvious from the web site how to go beyond the chmod and chown fixes. What does the socks file do anyway? Thanks Andrew G Morris ILT Advisor (Technical) JISC RSC West Midlands 01902 824434 07980 982738 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Mark Papadakis Head of RD Phaistos Networks, S.A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot connect to local mysql server through socket
Hi, I am trying to set up a mail server using Postfix, Web-cyradm and mysql on SusE 8. I have followed all the steps in Luc de Louw's documentation so far and MySQL server is running. When I try to use the scripts that came with Web-Cyradm to create the databases and tables I get the folowing error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have checked that mysqld is running and I have moved the mysql.sock file from /tmp to /var/lib/mysql, checked ownership and permissions but still no luck. As you can probably tell, I am no database guy so please excuse if it is a real daft question. Thanks - 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
re: cannot connect to local mysql server through socket
Lawrence, Monday, September 30, 2002, 2:47:44 PM, you wrote: LS I am trying to set up a mail server using Postfix, Web-cyradm and mysql LS on SusE 8. I have followed all the steps in Luc de Louw's documentation LS so far and MySQL server is running. When I try to use the scripts that LS came with Web-Cyradm to create the databases and tables I get the LS folowing error: LS ERROR 2002: Can't connect to local MySQL server through socket LS '/var/lib/mysql/mysql.sock' (2) LS I have checked that mysqld is running and I have moved the mysql.sock LS file from /tmp to /var/lib/mysql, checked ownership and permissions but LS still no luck. LS As you can probably tell, I am no database guy so please excuse if it is LS a real daft question. You shouldn't move mysql.sock file. You can just set up path to the socket file in the my.cnf or with --socket option of mysqld. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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)
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