issues running mysql, mysql5?

[Ryan Schmidt]

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".