Opened 15 years ago

Closed 15 years ago

#22472 closed defect (duplicate)

mysql5-server @5.1.40_0 - mysql user name incorrect

Reported by: sakutz@… Owned by: ryandesign (Ryan Carsten Schmidt)
Priority: Normal Milestone:
Component: ports Version: 1.8.1
Keywords: Cc:
Port: mysql5-server

Description

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.

Change History (2)

comment:1 Changed 15 years ago by mf2k (Frank Schima)

Owner: changed from macports-tickets@… to ryandesign@…
Port: mysql5-server added

comment:2 Changed 15 years ago by ryandesign (Ryan Carsten Schmidt)

Resolution: duplicate
Status: newclosed

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

Note: See TracTickets for help on using tickets.