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]
