Opened 8 years ago

Closed 8 years ago

#39533 closed defect (invalid)

mysql55: Unable to install db tables

Reported by: conradwt (Conrad Taylor) Owned by: pixilla (Bradley Giesbrecht)
Priority: Normal Milestone:
Component: ports Version: 2.1.3
Keywords: Cc:
Port: mysql55

Description (last modified by larryv (Lawrence Velázquez))

$ 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

Change History (6)

comment:1 Changed 8 years ago by larryv (Lawrence Velázquez)

Cc: pixilla@… openmaintainer@… removed
Description: modified (diff)
Owner: changed from macports-tickets@… to pixilla@…
Summary: Unable to install db tablesmysql55: Unable to install db tables

“openmaintainer” is a dummy address.

comment:2 Changed 8 years ago by pixilla (Bradley Giesbrecht)

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

comment:3 Changed 8 years ago by 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

comment:4 in reply to:  2 Changed 8 years ago by 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.

comment:5 in reply to:  3 ; Changed 8 years ago by 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.

comment:6 in reply to:  5 Changed 8 years ago by pixilla (Bradley Giesbrecht)

Resolution: invalid
Status: newclosed

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.

Note: See TracTickets for help on using tickets.