Gentlemen Thank you VERY much ! Am now back to working again....
Then when Amazon delivery my MySQL books I should be a lot wiser too ! Very much appreciated all the assistance Andy On 7/22/05 3:12 PM, "Santino" <[EMAIL PROTECTED]> wrote: > 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]