mysql5-server @5.1.40_0 - mysql user name incorrect

[sakutz@…]

I installed mysql5-server and the following output was produced:

1]root@legacy:macports$ sudo port install mysql5-server
--->  Computing dependencies for mysql5-server
--->  Fetching mysql5
--->  Verifying checksum(s) for mysql5
--->  Extracting mysql5
--->  Applying patches to mysql5
--->  Configuring mysql5
--->  Building mysql5
--->  Staging mysql5 into destroot
--->  Installing mysql5 @5.1.40_0
The MySQL client has been installed.
If you also want a MySQL server, install the mysql5-server port.
--->  Activating mysql5 @5.1.40_0
--->  Cleaning mysql5
--->  Fetching mysql5-server
--->  Verifying checksum(s) for mysql5-server
--->  Extracting mysql5-server
--->  Configuring mysql5-server
--->  Building mysql5-server
--->  Staging mysql5-server into destroot
--->  Creating launchd control script
###########################################################
# A startup item has been generated that will aid in
# starting mysql5-server with launchd. It is disabled
# by default. Execute the following command to start it,
# and to cause it to launch at startup:
#
# sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
###########################################################
--->  Installing mysql5-server @5.1.40_0
******************************************************
* In order to setup the database, you might want to run
* sudo -u mysql mysql_install_db5
* if this is a new install
******************************************************
--->  Activating mysql5-server @5.1.40_0
--->  Cleaning mysql5-server

The problem is that "sudo -u mysql mysql_install_db5" will fail because the "mysql" user does not exist, at least on 10.6.2. All system/administrative user name begin with an underscore, thus the following command is correct:

"sudo -u _mysql mysql_install_db5"

Failure to use the correct user will result in incorrect permissions everywhere and about 24 hours of great frustration.

[ryandesign (Ryan Carsten Schmidt)]

Sorry for the trouble! I'll handle this in #13705.