Marty Ray wrote:


I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I cannot get it to start up. I first tried manual startup using the unix commands as detailed in the manual. I kept getting the message mysql shutting down before I could hit ctl-Z. Then when I tried to connect, it stated:

First, you can avoid ctl-z like this


  cd /usr/local/mysql
  sudo -v
  sudo bin/mysqld_safe &

The reason mysqld failed to start should be in the error log. The error log should be in mysql's data directory (probably /usr/local/mysql/data) and should be named hostname.err (where hostname is the name of your computer).

Most likely you have a permissions problem. Typically, this is either because mysql doesn't have permission to write to /tmp or because root instead of mysql owns the data directory and/or its contents. If so, you can fix these with

sudo chmod 1777 /tmp

and

sudo chown -R mysql:mysql /usr/local/mysql/data

respectively.

"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

Right. The server (mysqld) didn't start, so there's nothing for the client (mysql) to talk to.


I then tried installing the automatic startup routine, restarted the computer and running mysql and I get the same message.

Right. The automatic startup routine effectively does the same thing as you running mysqld_safe. You need to find and fix the problem which keeps mysqld from starting, then both startup methods should work.


Any suggestions?

Thanks!

Marty Ray

Michael



-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to