STOPPING server from pid file - mysql 5.0
chris (2005-10-30 20:32:09)
If you've stumbled upon this posting, it's probably because you're having problems starting a newly built mysql server. It took me a while to sort this out - I have just put mysql 5.0 (actually 5.0.15-standard-log) on my laptop, but had trouble starting the server when using my existing my.cnf which I'd been using with 4.0.1-log. I guess mysql 5 is a bit more fussy over permissions (mysql has always been a bit of a permissions whore). I noticed that when I commented my datadir line out of the my.conf, the server would start just fine, but of course it used the default data locations, so none of my databases were visible.. Well at least that pointed out where the problem lied - it was a permissions issue on the data directory. All I did was a chown -R mysql.mysql /export/data and everything was fine again
hope that helps somebody..