On Mar 31, 2007, at 18:08, Chris Drackett wrote:
when I try and run it i get the following:
Hobbes:~ cwd$ ps auxww | grep mysql cwd 4715 1.0 -0.0 27372 428 p3 S+ 6:05PM 0:00.00 grep mysql mysql 4674 0.0 -0.5 39940 10444 ?? SNs 6:04PM 0:00.21 /System/Library/Frameworks/CoreServices.framework/ Frameworks/Metadata.framework/Versions/A/Support/mdimportserver
Hmm. I wonder why the mysql user is running Mac OS X's metadata import server. In any case, it looks like mysql is not running.
and if I try and start the server I get:
Hobbes:~ cwd$ /opt/local/share/mysql5/mysql/mysql.server start Starting MySQL/opt/local/share/mysql5/mysql/mysql.server: line 151: kill: (4732) - No such process ERROR!
Well, the command you should use to start the mysql5 server now, and have it start every time you boot your computer, is: sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist The command to stop the mysql5 server now, and prevent it from starting when you boot your computer, is: sudo launchctl unload -w /Library/LaunchDaemons/ org.macports.mysql5.plist Before this will work properly, though, you will probably have to initialize the mysql5 databases. The way to do that is: sudo -u mysql mysql_install_db5 If you still can't start the mysql5 server after that, see if anything useful is in the error log. The error log is in /opt/local/ var/db/mysql5 in a file whose name ends with ".err", for example "localhost.err".