Installing 4.0.18 on a Mac OS X 10.3.3 system creates the "data" directory and its contents as owned by "root" instead of "mysql."
I tried blowing away the data/mysql directory and running scripts/mysql_install_db. I tried logging in as root and doing a recursive chown. Finally I deleted everything, installed 4.0.17 instead and the tables had the right owners and the database started OK.
Representative errors:
040317 12:43:56 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040317 12:43:57 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040317 12:43:57 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...
040317 12:43:58 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
040317 12:43:59 InnoDB: Started
040317 12:43:59 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040317 12:43:59 Aborting
040317 12:43:59 InnoDB: Starting shutdown...
040317 12:44:01 InnoDB: Shutdown completed
040317 12:44:01 /usr/local/mysql-standard-4.0.18-apple-darwin6.8-powerpc/bin/mysqld: Shutdown Complete
040317 12:44:01 mysqld ended
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
