HELP mysql.sock is missing in Mac OS X
I start MySQL and it seems to start the server normally TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 040512 21:27:05 mysqld ended but when i try to open the mysql console it sends me the message: TrentCioran:/usr/local/mysql TrentCioran$ /usr/local/mysql/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I've been searching for the mysql.sock file but it is missing. Can someone help me?? Thanx Trent -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HELP mysql.sock is missing in Mac OS X
Jose Manuel Islas Romero wrote: I start MySQL and it seems to start the server normally TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 040512 21:27:05 mysqld ended It's not starting normally. It's starting and dying, that's why it says mysqld ended. but when i try to open the mysql console it sends me the message: TrentCioran:/usr/local/mysql TrentCioran$ /usr/local/mysql/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I've been searching for the mysql.sock file but it is missing. That's because mysqld isn't running. When you get mysqld running this problem will go away. The reason why it's not running should be noted in the error file, which should be: /usr/local/mysql/data/hostname.err This will have a notation where mysqld tried to start and then died. It seems like lots of people starting mysqld on OS X for the first time have a permission error on the data directory. It should be owned by mysql (the user already exists in both 10.2 and 10.3) and the group should be mysql. This problem is error number 13, but other error numbers will be explained by the perror command: /usr/local/mysql/bin/perror errornumber Good luck, Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HELP mysql.sock is missing in Mac OS X
iH doesn't look as tho mysqld is running -- mysqld ended did you install the standard database files? what about the permissions? can mysqld read those files check the error log in the data directory - hcir On May 12, 2004, at 6:53 PM, Jose Manuel Islas Romero wrote: I start MySQL and it seems to start the server normally TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 040512 21:27:05 mysqld ended but when i try to open the mysql console it sends me the message: TrentCioran:/usr/local/mysql TrentCioran$ /usr/local/mysql/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I've been searching for the mysql.sock file but it is missing. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql.sock is missing - Please....
Hi, On Sun, 2003-02-02 at 00:25, B. van Ouwerkerk wrote: If it gives errors about creating/writing mysql.sock, check the permissions/ownership of directory /var/lib/mysql.. Check the manual for the right permissions... Might depend on your distro, AFAIK mysql.sock would normally live in /tmp Yes, you're right, i only used that directory (/var/lib/mysql) because he said: I'm staring mysql with mysql -u root mysql but I'm geting this error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I cannot find Mysql.sock anywhere, but I so i thought his mysql server was configured to have the sock file there. :-) Thanx, -- Diana Soares - 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 is missing - Please....
If it gives errors about creating/writing mysql.sock, check the permissions/ownership of directory /var/lib/mysql.. Check the manual for the right permissions... Might depend on your distro, AFAIK mysql.sock would normally live in /tmp B. - 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 is missing - Please....
Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d, don't ask me why, I'm new to this things. That's because the rpm installation puts there a file mysql to be easier to configure starting services If you want mysql to start everytime your machine reboots, have a look at, for example chkconfig command or: http://www.mysql.com/doc/en/Automatic_start.html If you have /etc/rc.d/init.d/mysql i guess you can try the following: First be shure that mysqld is running (with ps auxw | grep mysql or netstat -ta | grep mysql...). You may also stop the server with /etc/rc.d/init.d/mysql stop Start the server: /etc/rc.d/init.d/mysql start If it gives errors about creating/writing mysql.sock, check the permissions/ownership of directory /var/lib/mysql.. Check the manual for the right permissions... Good luck, On Tue, 2003-01-28 at 00:38, Pedro Leite wrote: Any help from good samaritans? I have no idea to solve this mess! TIA - Original Message - From: Pedro Leite [EMAIL PROTECTED] To: TdA [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, January 27, 2003 10:23 AM Subject: Re: mysql.sock is missing Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d, don't ask me why, I'm new to this things. Any more help would be much appreciated. TIA - Original Message - From: TdA [EMAIL PROTECTED] To: Pedro Leite [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 27, 2003 7:45 AM Subject: Re: mysql.sock is missing There are a couple of things you can try, first make sure your process is started. /etc/rc.d/ mysql start should do the trick. TDA - Original Message - From: Pedro Leite [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 26, 2003 11:04 PM Subject: mysql.sock is missing Hi, I'm staring mysql with mysql -u root mysql but I'm geting this error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I cannot find Mysql.sock anywhere, but I was running mysql before reboot the linux sytem. What can I do to recover/reinstall/run the mysql server again? I didn't find mysql.server, but I do have mysql.server* on dir /usr/share/mysql. I'm running Mandrake 9 and Mysql-323.54a (rpm). Thank you in advance Pedro -- Diana Soares - 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 is missing - Please....
Hi, I don't know who is receiving my message, but i have an important request on you. I also have the same problem. I installed MySQL on my server and after reboot i got the error message when starting mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) the file mysqld.sock doesn't exist on the server. I also can't find the file mysql.server. I'm using Debian 3.0. Debian-Package: mysql-server shell mysql --version gives the following: mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686) Please help me! Thank you - 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 is missing - Please....
Thomas, I installed MySQL on my server and after reboot i got the error message when starting mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Is mysqld up and running? Try ps xa | grep mysqld. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Thomas Schlagbauer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 2:04 PM Subject: Re: mysql.sock is missing - Please Hi, I don't know who is receiving my message, but i have an important request on you. I also have the same problem. I installed MySQL on my server and after reboot i got the error message when starting mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) the file mysqld.sock doesn't exist on the server. I also can't find the file mysql.server. I'm using Debian 3.0. Debian-Package: mysql-server shell mysql --version gives the following: mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686) Please help me! Thank you - 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 is missing
There are a couple of things you can try, first make sure your process is started. /etc/rc.d/ mysql start should do the trick. TDA - Original Message - From: Pedro Leite [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 26, 2003 11:04 PM Subject: mysql.sock is missing Hi, I'm staring mysql with mysql -u root mysql but I'm geting this error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I cannot find Mysql.sock anywhere, but I was running mysql before reboot the linux sytem. What can I do to recover/reinstall/run the mysql server again? I didn't find mysql.server, but I do have mysql.server* on dir /usr/share/mysql. I'm running Mandrake 9 and Mysql-323.54a (rpm). Thank you in advance Pedro - 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 is missing
Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d, don't ask me why, I'm new to this things. Any more help would be much appreciated. TIA - Original Message - From: TdA [EMAIL PROTECTED] To: Pedro Leite [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 27, 2003 7:45 AM Subject: Re: mysql.sock is missing There are a couple of things you can try, first make sure your process is started. /etc/rc.d/ mysql start should do the trick. TDA - Original Message - From: Pedro Leite [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 26, 2003 11:04 PM Subject: mysql.sock is missing Hi, I'm staring mysql with mysql -u root mysql but I'm geting this error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I cannot find Mysql.sock anywhere, but I was running mysql before reboot the linux sytem. What can I do to recover/reinstall/run the mysql server again? I didn't find mysql.server, but I do have mysql.server* on dir /usr/share/mysql. I'm running Mandrake 9 and Mysql-323.54a (rpm). Thank you in advance Pedro - 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 - 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 is missing - Please....
Any help from good samaritans? I have no idea to solve this mess! TIA - Original Message - From: Pedro Leite [EMAIL PROTECTED] To: TdA [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, January 27, 2003 10:23 AM Subject: Re: mysql.sock is missing Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d, don't ask me why, I'm new to this things. Any more help would be much appreciated. TIA - Original Message - From: TdA [EMAIL PROTECTED] To: Pedro Leite [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 27, 2003 7:45 AM Subject: Re: mysql.sock is missing There are a couple of things you can try, first make sure your process is started. /etc/rc.d/ mysql start should do the trick. TDA - Original Message - From: Pedro Leite [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 26, 2003 11:04 PM Subject: mysql.sock is missing Hi, I'm staring mysql with mysql -u root mysql but I'm geting this error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I cannot find Mysql.sock anywhere, but I was running mysql before reboot the linux sytem. What can I do to recover/reinstall/run the mysql server again? I didn't find mysql.server, but I do have mysql.server* on dir /usr/share/mysql. I'm running Mandrake 9 and Mysql-323.54a (rpm). Thank you in advance Pedro - 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 - 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 is missing
On Mon, 2003-01-27 at 11:23, Pedro Leite wrote: Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d, don't ask me why, I'm new to this things. Any more help would be much appreciated. TIA That's the directory where it should be. You can also start with service mysql start Adolfo sql, query - 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 is missing
Hi, I'm staring mysql with mysql -u root mysql but I'm geting this error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I cannot find Mysql.sock anywhere, but I was running mysql before reboot the linux sytem. What can I do to recover/reinstall/run the mysql server again? I didn't find mysql.server, but I do have mysql.server* on dir /usr/share/mysql. I'm running Mandrake 9 and Mysql-323.54a (rpm). Thank you in advance Pedro - 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