#39533: mysql55: Unable to install db tables -------------------------+----------------------- Reporter: conradwt@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.1.3 Resolution: | Keywords: Port: mysql55 | -------------------------+----------------------- Changes (by larryv@…): * cc: pixilla@…, openmaintainer@… (removed) * owner: macports-tickets@… => pixilla@… Old description:

{{{ $ 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

New description: {{{ $ 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 -- Comment: “openmaintainer” is a dummy address. -- Ticket URL: <https://trac.macports.org/ticket/39533#comment:1> MacPorts <http://www.macports.org/> Ports system for OS X

#39533: mysql55: Unable to install db tables -------------------------+----------------------- Reporter: conradwt@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.1.3 Resolution: | Keywords: Port: mysql55 | -------------------------+----------------------- Comment (by 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 [http://dev.mysql.com/doc/refman/4.1/en/external-locking.html external- locking] from mysql 4.0.3 onward. {{{ $ grep locking /etc/my.cnf }}} -- Ticket URL: <https://trac.macports.org/ticket/39533#comment:3> MacPorts <http://www.macports.org/> Ports system for OS X

#39533: mysql55: Unable to install db tables -------------------------+----------------------- Reporter: conradwt@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.1.3 Resolution: | Keywords: Port: mysql55 | -------------------------+----------------------- Comment (by conradwt@…): Replying to [comment:3 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 [http://dev.mysql.com/doc/refman/4.1/en/external-locking.html 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. -- Ticket URL: <https://trac.macports.org/ticket/39533#comment:5> MacPorts <http://www.macports.org/> Ports system for OS X