#39728: mysql55 @5.5.32_1 mysql_install_db fails when using _mysql user -------------------------------------+-------------------------------- Reporter: pearcemerritt@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.1.3 Keywords: _mysql mysql_install_db | Port: mysql55 -------------------------------------+-------------------------------- OS: 10.6.8[[BR]] Xcode: 3.2.6 The following runs successfully: {{{ $ sudo port selfupdate $ sudo port install mysql55 $ sudo port install mysql55-server }}} Then, this fails: {{{ ~$ sudo -u _mysql /opt/local/lib/mysql55/bin/mysql_install_db Installing MySQL system tables... 130714 12:39:01 [ERROR] /opt/local/lib/mysql55/bin/mysqld: Can't find file: './mysql/db.frm' (errno: 13) ERROR: 1017 Can't find file: './mysql/db.frm' (errno: 13) 130714 12:39:01 [ERROR] Aborting 130714 12:39:01 [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! }}} It does not fail if I omit {{{-u _mysql}}}. However, omitting {{{-u _mysql}}} causes other errors later (e.g. trying to run {{{mysqld_safe}}} fails, etc.) -- Ticket URL: <https://trac.macports.org/ticket/39728> MacPorts <http://www.macports.org/> Ports system for OS X