Error when starting mysql on Mac OS 10.5

Question

Hi,

I had a problem with my MySQL installation here the other day. After doing everything I could think of to no avail, I decided to reinstall the whole thing.

I installed the package format of the installation from mysql.com, and ran the installer. It installed it right where it was before i uninstalled it: /usr/local/mysql.

So I try to do this:

sudo echo
sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &

And I get this in response:

[3] 505
mysqld_safe Logging to '/usr/local/mysql/data/PB15.lan.err'.
mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
mysqld_safe mysqld from pid file /usr/local/mysql/data/PB15.lan.pid ended

When I try to do: sudo mate /usr/local/mysql/data/PB15.lan.err, I get an empty document.

Any ideas on what to do?

Answer 1

I know this isn't answering your question, but MAMP is a great way to go when using MySQL on Mac OS X. Not only do you not have to worry about installing MySQL, but you can also easily move your MySQL setup between computers.

Steve

Answer 2

The MySQL binary packages from mysql.com come with a preference pane for starting and stopping it. Why aren't you using these? Even if you have a good reason not to, try to use it just to see if it works.

Another thing to check is to make sure you are downloading the 32-bit version of MySQL unless you are on a 64-bit Mac. If you aren't sure, just try the 32-bit version anyway.

Answer 3

The solution in the end was installing snow lepoard, giving me a fresh install, and everything just works again. Thanks to everyone who took the time to answer.

Erik