Here is what I got from the .err file:
040212 15:54:38 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040212 15:54:38 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040212 15:54:38 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
040212 15:54:39 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
040212 15:54:39 InnoDB: Started; log sequence number 0 0
040212 15:54:39 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040212 15:54:39 mysqld ended
Hmmm...
Marty Ray
On Feb 12, 2004, at 4:56 PM, Michael Stassen wrote:
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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
