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]

Reply via email to