mysql5 does not run

[bpabbott@…]

I'm having trouble running mysql5. With Lion, I was successful following the instructions at the link below.

wiki:howto/MAMP#mysql

I've recently upgraded to Mavericks and returned to these same instructions.

sudo port install mysql5-server

sudo -u mysql mysql_install_db5 
sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ 
sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ 

The directory /opt/local/var/log/mysql5 did not exist, so I created it and changed the permissions.

sudo mkdir -p /opt/local/var/log/mysql5
sudo chown -R mysql:mysql /opt/local/var/log/mysql5/ 

Next I activated my MySQL server.

sudo port load mysql5-server

Which returned the error below.

Error: org.macports.load for port mysql5-server returned: Launchd plist /Library/LaunchDaemons/org.macports.mysql5.plist was not found
Please see the log file for port mysql5-server for details:
    /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql5/mysql5-server/main.log
To report a bug, follow the instructions in the guide:
    http://guide.macports.org/#project.tickets
Error: Processing of port mysql5-server failed

The log contains a bit more info.

version:1
:debug:main Executing org.macports.main (mysql5-server)
:debug:load load phase started at Fri Dec 13 18:27:18 EST 2013
:debug:load Executing org.macports.load (mysql5-server)
:error:load org.macports.load for port mysql5-server returned: Launchd plist /Library/LaunchDaemons/org.macports.mysql5.plist was not found
:debug:load Error code: NONE
:debug:load Backtrace: Launchd plist /Library/LaunchDaemons/org.macports.mysql5.plist was not found
    while executing
"$procedure $targetname"
:info:load Warning: targets not executed for mysql5-server: org.macports.load
:notice:load Please see the log file for port mysql5-server for details:
    /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql5/mysql5-server/main.log

[ryandesign (Ryan Carsten Schmidt)]

Installing the mysql5-server port should have created the _mysql user (note the preceding underscore), and the /opt/local/var/log/mysql5 directory, and the /Library/LaunchDaemons/org.macports.mysql5.plist file, and it does in fact do all those things on my Mavericks system. What is the output of these commands on your system:

port -v installed | grep mysql5
port contents mysql5-server

[bpabbott@…]

Since my post, I rebooted, uninstalled mysql5 & mysql5-server, reinstalled, and then rebooted again. With that I was able to get everything running. Now I have no idea what when wrong.

In any event, thanks for the quick reply.

[ryandesign (Ryan Carsten Schmidt)]

Ok good. I suspected that either mysql5-server was not installed or for some reason did not contain what it should, though I can think of no way for that to have happened. Glad you got it working.