OK

Now open the terminal and type:
cd /usr/local/mysql/
./scripts/mysql_install_db

and restart mysql.

Santino Cusimano

At 14:34 -0400 22-07-2005, Andy Hilton wrote:
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]


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

Reply via email to