[MacPorts] #39728: mysql55 @5.5.32_1 mysql_install_db fails when using _mysql user

[MacPorts]

#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