Upgrade from 3.23 to 4.0 - mysql.sock error
Greetings all, I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved the old installation to a directory called old_mysql in my home directory. I can start the new installation using mysqld_safe . Now, when I try to do something like: /new/install/mysqladmin -u root -p version it says it can't connect because there is no /tmp/mysql.sock. And that is the case. The mysql.sock file is in /var/lib/mysql/mysql.sock When I do something like: old_mysql/mysqladmin -u root -p version it can connect and, in fact, I can connect to the new mysql server by using old_mysql/mysql -u root -p Should I just go on using the old clients? Why is there no /tmp/mysql.sock? How can I make mysql create one? Help! and Thanks!!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrade from 3.23 to 4.0 - mysql.sock error
The correct way to deal with this is to edit /etc/my.cnf and, in the mysqld section set the location of the socket. [mysqld] socket = /tmp/mysql.sock if there are other systems expecting it to be at the new location, a simple end run might be to create a link at /tmp/mysql.sock - /var/lib/mysql/mysql.sock. - michael dykman - [EMAIL PROTECTED] Jough P wrote: Greetings all, I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved the old installation to a directory called old_mysql in my home directory. I can start the new installation using mysqld_safe . Now, when I try to do something like: /new/install/mysqladmin -u root -p version it says it can't connect because there is no /tmp/mysql.sock. And that is the case. The mysql.sock file is in /var/lib/mysql/mysql.sock When I do something like: old_mysql/mysqladmin -u root -p version it can connect and, in fact, I can connect to the new mysql server by using old_mysql/mysql -u root -p Should I just go on using the old clients? Why is there no /tmp/mysql.sock? How can I make mysql create one? Help! and Thanks!!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrade from 3.23 to 4.0 - mysql.sock error
Okay, so what I did to solve this was: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock That seems like a bit of a hack though. The my.cnf file has this line: socket=/var/lib/mysql/mysql.sock Anyone know why it's looking in /etc ? On Jul 14, 2004, at 4:53 PM, Jough P wrote: Greetings all, I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved the old installation to a directory called old_mysql in my home directory. I can start the new installation using mysqld_safe . Now, when I try to do something like: /new/install/mysqladmin -u root -p version it says it can't connect because there is no /tmp/mysql.sock. And that is the case. The mysql.sock file is in /var/lib/mysql/mysql.sock When I do something like: old_mysql/mysqladmin -u root -p version it can connect and, in fact, I can connect to the new mysql server by using old_mysql/mysql -u root -p Should I just go on using the old clients? Why is there no /tmp/mysql.sock? How can I make mysql create one? Help! and Thanks!!! -- 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]
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: mysql.sock error
Hello. On Fri 2002-12-06 at 14:32:13 -0600, [EMAIL PROTECTED] wrote: after trying this it shows mysql as running, but /tmp/mysql.sock as not being created. i stopped mysql and then started it again, and the same thing happened...still no mysql.sock? should i just reinstall? what is the best way to go about fixing this problem? thank you. You can use mysqladmin -h127.0.0.1 variables to determine where the socket file should be (according to the MySQL server). Assure that it is indeed /tmp/mysql.sock as you/the client think it is. Read http://www.mysql.com/doc/en/Can_not_connect_to_server.html and follow the suggestions there. If that does not help, write again and describe which facts you have found out according to this page. HTH, Benjamin. -- [EMAIL PROTECTED] - 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: mysql.sock error
after trying this it shows mysql as running, but /tmp/mysql.sock as not being created. i stopped mysql and then started it again, and the same thing happened...still no mysql.sock? should i just reinstall? what is the best way to go about fixing this problem? thank you. jeff ps -wef | grep mysqld should show if the daemon is actually running or not. Check to make sure. Then, ls /tmp/mysql.sock will show you if the mysql file was created or not. Bhavin. - Original Message - From: Jeff Hollingshead [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 4:16 PM Subject: mysql.sock error at first when trying to run mysql it did this: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 3124 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql 021121 02:27:42 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql then, i stopped mysql and gave the command again and it seemed to work: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 5456 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql however, when trying to connect to mysql it does this still: Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! any help appreciated - 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
mysql.sock error
at first when trying to run mysql it did this: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 3124 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql 021121 02:27:42 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql then, i stopped mysql and gave the command again and it seemed to work: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 5456 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql however, when trying to connect to mysql it does this still: Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! any help appreciated - 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: mysql.sock error
Check if mysql is started by entering ps -ax | grep -i mysql If not started try: service mysql start Adolfo -Original Message- From: Jeff Hollingshead [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 5:17 PM To: [EMAIL PROTECTED] Subject: mysql.sock error at first when trying to run mysql it did this: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 3124 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql 021121 02:27:42 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql then, i stopped mysql and gave the command again and it seemed to work: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 5456 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql however, when trying to connect to mysql it does this still: Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! any help appreciated - 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: mysql.sock error
ps -wef | grep mysqld should show if the daemon is actually running or not. Check to make sure. Then, ls /tmp/mysql.sock will show you if the mysql file was created or not. Bhavin. - Original Message - From: Jeff Hollingshead [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 4:16 PM Subject: mysql.sock error at first when trying to run mysql it did this: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 3124 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql 021121 02:27:42 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql then, i stopped mysql and gave the command again and it seemed to work: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 5456 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql however, when trying to connect to mysql it does this still: Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! any help appreciated - 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
Getting started - mysql.sock error
Hi, Iam back on this list after being diverted by job change - moving house etc. I've just set up one of my machines with Mandrake 9.0 and went for the included MySQL install (3.23). When I try to do anything I get an error saying that the 'mysql.sock' could not be found. I remember that this has been a regular chestnut but can't find any solutions in the archive or elsewhere. Any clues? If I download and install the v4 RPMs will that cure it? So far I haven't touched MySQL on this Linux box so no seeting should be effective. Regards George - 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: Getting started - mysql.sock error
George, Tuesday, October 15, 2002, 2:55:14 PM, you wrote: GP Iam back on this list after being diverted by job change - moving house etc. GP I've just set up one of my machines with Mandrake 9.0 and went for the GP included MySQL install (3.23). GP When I try to do anything I get an error saying that the 'mysql.sock' could GP not be found. Is MySQL server running? GP I remember that this has been a regular chestnut but can't find any GP solutions in the archive or elsewhere. GP Any clues? GP If I download and install the v4 RPMs will that cure it? -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c 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
RE: Getting started - mysql.sock error
Ed, Its slightly difficult doing it exactly as my email is on my W2K laptop - but here goes: error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! If I run mysqld, I get an error: Can't start server : Bind on unix socket: Permission denied Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? Please un-stump me. Stumped George -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 1:31 pm To: George Pitcher; [EMAIL PROTECTED] Subject: RE: Getting started - mysql.sock error When I try to do anything I get an error saying that the 'mysql.sock' could not be found. Actually, you probably got a more detailed error message than this. Try posting the entire error message - I promise you that would be more useful ;) I remember that this has been a regular chestnut but can't find any solutions in the archive or elsewhere. Look harder, grasshopper ;) If I download and install the v4 RPMs will that cure it? How would that help? Think about it logically. The quick answer to your question is create a soft link from where the mysql.sock file is to where it expects it to be. Since you didn't post the entire error message, it's not possible to be more specific, but you might try looking in /tmp and /var/lib/mysql. - 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: RE: Getting started - mysql.sock error
George, Tuesday, October 15, 2002, 5:09:47 PM, you wrote: GP Its slightly difficult doing it exactly as my email is on my W2K laptop - GP but here goes: GP error: 'Can't connect to local MySQL server through socket GP '/var/lib/mysql/mysql.sock' (2)' GP Check that mysqld is running and that the socket: GP '/var/lib/mysql/mysql.sock' exists! GP If I run mysqld, I get an error: GP Can't start server : Bind on unix socket: Permission denied GP Do you already have another mysqld server running on socket: GP /var/lib/mysql/mysql.sock ? Run ps ax | grep mysqld to see if mysqld is already running. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c 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
RE: RE: Getting started - mysql.sock error
Egor, Run ps ax | grep mysqld to see if mysqld is already running. This returns '11276 pts/1S 0:00 grep mysql' I have checked and cannot find mysql.sock anywhere. Cheers George - 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: mysql.sock error
Jay Paulson [EMAIL PROTECTED] writes: I'm running RedHat 7.1 and I'm trying to run mysql. I've gone and run the mysql_install_db Not good. If you had just started the script, it would have been done automatically - as it is, you created a set of files you can't access (root owns them, the db runs as user mysql). A chown -R mysql.mysql /var/lib/mysql would fix it. -- 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
mysql.sock error
I'm trying to start my first ever installation of mysql, so I've installed the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when I try to star the server I get the following message Can't connect ot local MySQL server through socket '/tmp/mysql.sock' When I do a find I can't find the mysql.sock file anywhere on my server. Any suggestions? - 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: mysql.sock error
Just had this same error and fixed it...with help. You need to set a symlink to the /tmp ln -s /tmp/mysql var/lib/mysql/mysql.sock I may have this backwards..I'll send it from home when I get there. M;) -Original Message- FROM: Nick Torenvliet TO: Mysql (E-mail) DATE: Thu 9/13/01 13:58 SUBJECT: mysql.sock error I'm trying to start my first ever installation of mysql, so I've installed the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when I try to star the server I get the following message Can't connect ot local MySQL server through socket '/tmp/mysql.sock' When I do a find I can't find the mysql.sock file anywhere on my server. Any suggestions? - 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: mysql.sock error
the sock file is in the /usr/lib/mysql dir i created a symlink of the file from there to /tmp On Thu, 2001-09-13 at 14:32, Nick Torenvliet wrote: I'm trying to start my first ever installation of mysql, so I've installed the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when I try to star the server I get the following message Can't connect ot local MySQL server through socket '/tmp/mysql.sock' When I do a find I can't find the mysql.sock file anywhere on my server. Any suggestions? - 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: mysql.sock error
Nick Torenvliet wrote: ...I've run ./configure Did you run 'make'? --- Rodney Broom Programmer: Desert.Net Keywords: sql, spam-off - 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: mysql.sock error
Well lets get it runningG Basic install nothing fancy ./configure make make install to fix your error create a symlink su to root ln -s var/lib/mysql/mysql.sock /tmp/mysql.sock Cheers M;) -Original Message- From: Nick Torenvliet [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 1:32 PM To: Mysql (E-mail) Subject: mysql.sock error I'm trying to start my first ever installation of mysql, so I've installed the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when I try to star the server I get the following message Can't connect ot local MySQL server through socket '/tmp/mysql.sock' When I do a find I can't find the mysql.sock file anywhere on my server. Any suggestions? - 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
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
mysql.sock error
I'm receiving the following error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/httpd/html/phpadmin2/lib.inc.php on line 119 what could be? thanks, Augusto - 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
Mysql.sock Error
My database was working fine then the server crashed and now I am getting this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) I have checked and verified that the file exists: srwxrwxrwx 1 root root0 Jan 16 23:00 mysql.sock It seems to have 0 bytes but it is there. I have rebooted my server, and I am still getting the error. I don't want to lose what I have in my database is there anyway of fixing this, I have searched the documentation and the only thing on mysql.sock is how to protect it from being deleted. Any help on how to go about fixing this is greatly appreciated. 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