RE: Need Help About mysql.sock ERROR
:-) I think the first issue is to make sure that the server is running. Typically the 'sock' file issue will solve itself if the server is running. -Original Message- From: Ernesto Silva [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 12:38 AM To: [EMAIL PROTECTED] Subject: Re: Need Help About mysql.sock ERROR You have several options, here is, I think, the easiest: First you need to locate the sock file. The location depends on the distribution (in my system is in /tmp). Use find / -name mysql.sock. On some distributions the name can be slightly different, for example mysqld.sock. Then create a symbolic link in '/var/lib/mysql/' pointing mysql.sock Ernesto - Original Message - From: Pratchaya Chatuphian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 09, 2003 11:50 PM Subject: Need Help About mysql.sock ERROR ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Thank u for advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need Help About mysql.sock ERROR
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Thank u for advance
Re: Need Help About mysql.sock ERROR
You have several options, here is, I think, the easiest: First you need to locate the sock file. The location depends on the distribution (in my system is in /tmp). Use find / -name mysql.sock. On some distributions the name can be slightly different, for example mysqld.sock. Then create a symbolic link in '/var/lib/mysql/' pointing mysql.sock Ernesto - Original Message - From: Pratchaya Chatuphian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 09, 2003 11:50 PM Subject: Need Help About mysql.sock ERROR ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Thank u for advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with mysql.sock error
I had the same problem with suse 7.2. I see that the path to mysql.sock is /var/lib/mysql/mysql.sock. this location of mysql.sock was a leftover from the mysql that i installed from the distribution. the downloaded version though stores the mysql.sock in /tmp/mysql.sock - i had to tell a few of my programs to look for it there. may you need to add a line in your php program to look for it there good luck harry a. adam wrote: I am having trouble with mysql... i keep getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was able to connect to MySQL server via command line client, but could not connect via web page with the error mysql.sock (111). - 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 - 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
help with mysql.sock error
I am having trouble with mysql... i keep getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was able to connect to MySQL server via command line client, but could not connect via web page with the error mysql.sock (111). - 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: help with mysql.sock error
su nobody ls -l /var/lib/mysql/mysql.sock Whatever user is trying to get it [such as nobody for a web server usually or the user]- make sure the user can access the file. Make sure you don't have maybe /var/lib/mysql to be 750 or something like that. Permissions is a big one. -- Mike - Original Message - From: adam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 8:39 PM Subject: help with mysql.sock error I am having trouble with mysql... i keep getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was able to connect to MySQL server via command line client, but could not connect via web page with the error mysql.sock (111). - 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 - 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: help with mysql.sock error
adam [EMAIL PROTECTED] writes: I am having trouble with mysql... i keep getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) You probably didn't start it the correct way, by using the included initscript (/etc/init.d/mysqld, also usable by service mysqld argument (start, stop etc)). This is also what would have been used had you used tksysv, ntsysv or chkconfig to turn the service on. If you use the mysql_install_db as root and then use safe_mysqld, you'll try to run the database as user mysql - but root will own the files. chown -R mysql.mysql /var/lib/mysql should fix the problem. -- Trond Eivind Glomsrød Red Hat, Inc. - 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