[EMAIL PROTECTED] wrote:
Michael, here are some snippets from the error log that look relevant,
from three times I tried to start:
050719 20:29:41 mysqld started
050719 20:29:46 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data/ is case insensitive
050719 20:29:58 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
050719 20:29:58 mysqld ended
This time, you got a permission denied error, but I expect you fixed that
problem, because it doesn't show up in the next 2 attempts.
050719 20:33:07 mysqld started
050719 20:33:07 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data/ is case insensitive
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
050719 20:33:08 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050719 20:33:09 InnoDB: Log file ./ib_logfile0 did not exist: new to
be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050719 20:33:09 InnoDB: Log file ./ib_logfile1 did not exist: new to
be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050719 20:33:12 InnoDB: Started; log sequence number 0 0
050719 20:33:13 [ERROR] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050719 20:33:13 mysqld ended
This time, mysql can't find your privilege tables. Usually, this means you
haven't run mysql_install_db (probably in /usr/local/mysql/bin). Did you
follow the post-installation instructions
<http://dev.mysql.com/doc/mysql/en/post-installation.html>?
050719 21:50:42 mysqld started
050719 21:50:42 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data/ is case insensitive
050719 21:50:43 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...
050719 21:50:43 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
050719 21:50:44 InnoDB: Flushing modified pages from the buffer pool...
050719 21:50:44 InnoDB: Started; log sequence number 0 43634
050719 21:50:44 [ERROR] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050719 21:50:44 mysqld ended
This is the same problem as the second one, above.
Thank you.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
