mysql55: Unable to install db tables

[conradwt (Conrad Taylor)]

$ sudo -u _mysql /opt/local/lib/mysql55/bin/mysql_install_db
Password:
Installing MySQL system tables...
130625 13:20:41 [ERROR] /opt/local/lib/mysql55/bin/mysqld: unknown option '--skip-locking'
130625 13:20:41 [ERROR] Aborting

130625 13:20:41 [Note] /opt/local/lib/mysql55/bin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/opt/local/var/db/mysql55 for more information.

You can try to start the mysqld daemon with:

    shell> /opt/local/lib/mysql55/bin/mysqld --skip-grant &

and use the command line tool /opt/local/lib/mysql55/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /opt/local/lib/mysql55/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /opt/local/var/db/mysql55 that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /opt/local/lib/mysql55/bin/mysqlbug script!

System:

Mac OS X 10.8.4
Xcode 4.6.3

[larryv (Lawrence Velázquez)]

“openmaintainer” is a dummy address.

[pixilla (Bradley Giesbrecht)]

This ticket is for mysql55, do you have mysql55-server installed?

[pixilla (Bradley Giesbrecht)]

Where did the "--skip-locking" come from?

Do you have a cnf file (possibly /etc/my.cnf) that has a skip-locking option?

It looks like skip-locking is an old option replace by ​external-locking from mysql 4.0.3 onward.

$ grep locking /etc/my.cnf

[conradwt (Conrad Taylor)]

Replying to pixilla@…:

This ticket is for mysql55, do you have mysql55-server installed?

Yes, I was able to install mysql55-server cleanly with Xcode 4.6.3.

[conradwt (Conrad Taylor)]

Replying to pixilla@…:

Where did the "--skip-locking" come from?

Do you have a cnf file (possibly /etc/my.cnf) that has a skip-locking option?

It looks like skip-locking is an old option replace by ​external-locking from mysql 4.0.3 onward.

$ grep locking /etc/my.cnf

OK, I have found the offending file ~/.my.cnf and commented out 'skip-locking'. This issue can be closed.

[pixilla (Bradley Giesbrecht)]

Replying to conradwt@…:

OK, I have found the offending file ~/.my.cnf and commented out 'skip-locking'. This issue can be closed.

Thanks for reporting.