This would appear to be the relevant stuff - the err file was in the
mysql/data directory....
050722 14:23:32 mysqld started
050722 14:23:32 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data/ is case insensitive
050722 14:23:33 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050722 14:23:33 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050722 14:23:33 InnoDB: Flushing modified pages from the buffer pool...
050722 14:23:33 InnoDB: Started; log sequence number 0 43634
050722 14:23:33 [ERROR] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050722 14:23:33 mysqld ended
Andy
On 7/22/05 2:09 PM, "Michael Stassen" <[EMAIL PROTECTED]> wrote:
>
> Don't assume. Mysql keeps its data, including ibdata1, in the data directory.
> In your case, that's the default location, /usr/local/mysql/data/. The
> server, mysqld, runs as user mysql (by default), so the mysql user must have
> access to the data directory. You run the installer as root, however, so your
> data directory is probably owned by root, not mysql. You need to fix that.
> Do this:
>
> Open Terminal
> In Terminal, enter
> cd /usr/local/mysql/
> sudo chown -R mysql:mysql data
>
> That will change ownership of the data directory and its contents to the mysql
> user, which should enable mysqld to start. You can start mysqld from the
> command line in terminal like this:
>
> cd /usr/local/mysql/
> sudo -v
> sudo bin/mysqld_safe &
>
> or you can use the preferences pane if you installed it.
>
> If mysqld still fails to start, post the contents of
> /usr/local/mysql/hostname.err ("hostname" will be your Mac's name) in your
> next message.
>
> References:
> <http://dev.mysql.com/doc/mysql/en/default-privileges.html>
> <http://dev.mysql.com/doc/mysql/en/grant.html>
>
> Michael
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
