Bug #32072 Install fails on MacOS 10.5 - mysql_install_db missing files in /support-files
Submitted: 3 Nov 2007 4:43 Modified: 13 Nov 2007 9:02
Reporter: Brandon Jones Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.0.45 OS:MacOS (Leopard (10.5))
Assigned to: CPU Architecture:Any
Tags: mysql_install_db, scripts

[3 Nov 2007 4:43] Brandon Jones
Description:
On a FRESH ("Erase and Install") installation of Mac OS 10.5, I installed mySQL using the installer in mysql-5.0.45-osx10.4-i686.dmg.  The installer claims it completed successfully.

I can start mySQL from the commandline by running 'sudo /usr/local/mysql/bin/mysqld_safe &'.  However attempting to connect throws the error:

1046 - No database selected
select configuration_key as cfgKey, configuration_value as cfgValue from configuration
[TEP STOP]

Upon further investigation, the mysql_install_db script fails when I run 'sudo -u mysql mysql_install_db'

./mysql_install_db: line 118: my_print_defaults: command not found
FATAL ERROR: Could not find SQL file './support-files/mysql_system_tables.sql' in ./support-files or inside .

There are files in ./support-files but no .sql files at all.  The correct .sql files do reside in /usr/local/mysql-5.0.45-osx10.4-i686/share/.  But even copying those files over does not let the script complete; now it says:

FATAL ERROR Didn't find ./bin/mysqld
You should do a 'make install' before executing this script

I did not attempt to troubleshoot further.  Perhaps this is related to the permissions issues being experienced with OS 10.5, but not sure, so I'm going ahead and reporting this.

How to repeat:
Start with an Mac OS 10.5 system with no existing mySQL installation
Run standard installer in mysql-5.0.45-osx10.4-i686.dmg
Attempts to connect to mySQL or run mysql_install_db result in one of the two errors above
[13 Nov 2007 9:02] Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read about mysql_install_db options at http://dev.mysql.com/doc/refman/5.1/en/mysql-install-db.html