Bug #2388 Permissions problem in data/mysql under Mac OS X
Submitted: 14 Jan 2004 7:24 Modified: 29 Jan 2004 7:45
Reporter: Gustavo Delfino Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:mysql-standard-4.1.1-alpha OS:MacOS (Mac OS X 10.3.2)
Assigned to: Lenz Grimmer CPU Architecture:Any

[14 Jan 2004 7:24] Gustavo Delfino
After installing mysql-standard-4.1.1-alpha.pkg and MySQLStartupItem.pkg as instructed in the 
ReadMe.txt file my server wouldn't start.  Checking the log file I found the reason to be:

040114 10:43:04  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 
040114 10:43:04  mysqld ended

The problem solved after fixing permissions with:
sudo chown -R mysql /usr/local/mysql/data/

Shouldn't this be part of the installation script?

FYI, I have a cleanly installed Mac OS 10.3.2 system.


Gustavo Delfino
Caracas, Venezuela

How to repeat:
1) Install Mac OS 10.3.2
2) Install mysql-standard-4.1.1-alpha as instructed in ReadMe.txt file.
3) Try to start server

Suggested fix:
Add this at the end of scripts/mysql_install_db

sudo chown -R mysql /usr/local/mysql/data/
[29 Jan 2004 7:45] Lenz Grimmer
Yes, mysql_install_db fails to execute properly during the postinstall phase
(you can see this by checking the installer log: File -> Show Log) - this has
been fixed already for future releases. Your workaround is correct.

The fix is included in the following BK ChangeSet:

ChangeSet@1.1647.10.2, 2003-12-08 14:38:29+01:00, lenz@kallisto.local
  Fixed two packaging bugs:

   - postinstall of the Mac OS X PKG failed as a parameter for
     mysql_install_db was changed for MySQL 4.1
   - postinstall of the Server RPM failed as mysql_create_system_tables was
     missing from the file list