From: Date: March 17 2004 7:21pm Subject: Mac OS X permission errors in 4.0.18 List-Archive: http://lists.mysql.com/mysql/161984 Message-Id: MIME-Version: 1.0 (Apple Message framework v612) Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit 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