Re: Can't start MySQL on Mac OS X
Todd and Guys, Your advice helped me too. I think either Apple screwed up when set up /tmp directory to be writeable by root only or since MySQL package has bug or shall be installed ONLY as root user. - Nicos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Nicos, Actually, MySQL should be installed by an administrator, but it should be executed by root, which would permit the writing to the tmp dir. Meaning everytime you kick off MySQL server, you'll need to do so as root. This is usually how I dow it: cd /usr/local/mysql sudo echo sudo ./bin/mysqld_safe --user=mysql [Note: You'll need to do this on an account with administrator access. When you type sudo echo, you'll need to type your OS X user password.] My boy Marc has a slam'in site for MySQL on OS X http://www.entropy.ch. Since MySQL nor Apple have a startup script for MySQL (to kick off the DB at boot), I use the one he's generated - see his site for more details. Regards, Adam On Thursday, August 7, 2003, at 10:54 PM, Nicos Kekchidis wrote: Todd and Guys, Your advice helped me too. I think either Apple screwed up when set up /tmp directory to be writeable by root only or since MySQL package has bug or shall be installed ONLY as root user. - Nicos -- 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]
Can't start MySQL on Mac OS X
Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
If you did not shutdown the server prior to the upgrade, you could have left mysqld running, even after its socket was removed. Use ps to see if mysqld is still running, and kill it if necessary. Todd O'Bryan wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- 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 -- 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: Can't start MySQL on Mac OS X
Check your permissions in /usr/local/mysql, I think the package leaves some incorrectly set. The exact problem is usually logged in /usr/local/mysql/data/hostname.err this file is invaluable Cheers! --s On Wednesday, July 2, 2003, at 09:24 AM, Todd O'Bryan wrote: OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- 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 -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
I figured out what happened, though I don't know when it happened... I had screwed up the permissions for the /tmp/ directory, so the mysql user could not create the socket it needed there. A well-placed chmod and things are back in working order. Thanks to all for the suggestions, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]