Description:
After installation of MySQL 5.1.21-beta on a fresh MacOSX installation, the server doesn't start up.
The error logs says:
070926 09:00:14 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
070926 9:00:14 [ERROR] Can't find messagefile '/usr/local/mysql-5.1.21-beta-osx10.4-i686/share/english/errmsg.sys'
070926 9:00:14 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
/usr/local/mysql/bin/mysqld: Unknown error 1146
070926 9:00:14 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
070926 9:00:14 InnoDB: Started; log sequence number 0 46409
070926 9:00:14 [ERROR] Aborting
070926 9:00:14 InnoDB: Starting shutdown...
070926 9:00:16 InnoDB: Shutdown completed; log sequence number 0 46409
070926 9:00:16 [Note]
070926 09:00:16 mysqld_safe mysqld from pid file /usr/local/mysql/data/kai-voigts-computer.local.pid ended
How to repeat:
Get a fresh MacOSX, get mysql-5.1.21-beta, run Dmg installation and try to start the server.
Suggested fix:
/usr/local/mysql-5.1.21-beta-osx10.4-i686/share root# ln -s mysql/english english
/usr/local/mysql-5.1.21-beta-osx10.4-i686 root# ./scripts/mysql_install_db --user=mysql
After those two commands, the server can be started