[MacPorts] #28772: mysql_install_db5 works without '--user=_mysql' option, but mysql.user table not populated

[MacPorts]

#28772: mysql_install_db5 works without '--user=_mysql' option, but mysql.user
table not populated
-----------------------------------+----------------------------------------
 Reporter:  knightcode1@…          |       Owner:  ryandesign@…           
     Type:  defect                 |      Status:  new                    
 Priority:  Normal                 |   Milestone:                         
Component:  ports                  |     Version:  1.9.2                  
 Keywords:                         |        Port:  mysql5                 
-----------------------------------+----------------------------------------

Comment(by pixilla@…):

 Replying to [comment:7 knightcode1@…]:
 > I also downloaded the binary mysql package from mysql.com. I have its
 server up and running, but I had to run it from my user account and change
 the ownership of its 'data'  directory accordingly.
 This could conflict with your MacPorts mysql install. I recommend
 uninstalling this binary mysql package, delete or move /usr/local if it
 exists and delete or move /etc/my.cnf if it exists.
 > Maybe there's something I'm just not understanding about how to set this
 up with another user account. Should I just create another account in the
 System Preferences?
 No, the "_mysql" user account should already exist.

 {{{
 $ dscl localhost -list /Local/Default/Users
 $ dscl localhost -read /Local/Default/Users/_mysql
 }}}

 You should be able to start mysql5-server with:
 {{{
 $ sudo port load mysql5-server
 }}}

 Looks like the mysql root user exists and has a blank password. Add "-p"
 and hit enter "empty password" when prompted for a password.
 {{{
 $ mysqladmin5 -p -u root password 'new-password'
 }}}

-- 
Ticket URL: <https://trac.macports.org/ticket/28772#comment:8>
MacPorts <http://www.macports.org/>
Ports system for Mac OS