[bdude]

For some reason today mysql wasn't launching via System Preferences so I tried it via the command line to be greeted with this error:

Code:
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/roney.pid
070609 16:40:55  mysqld ended

I googled and tried some of the solutions available but it still wouldn't work.

[besson3c]

What are you seeing in your MySQL error log? Do you have any other instances running? Is your MySQL data in /usr/local/mysql/data?

[bdude]

The only error it gives is the one above, there is a data directory but when I cd into it I get a permission denied error.

[besson3c]

Your MySQL error file is usually in your MySQL data directory and has a .err extension. Either sudo ls into it, or enable root on your computer and su.

Are there any other instances of MySQL running? What happens when you do a: ps aux | grep mysql ?