MySQL will not start Snow Leopard 10.6.5

[eli312]

Hello,

 

I am trying to re-install MySQL after i did a clean upgrade to snow leopard the other day.

 

I downloaded Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive (mysql-5.5.8-osx10.6-x86_64.dmg)

from: http://dev.mysql.com/downloads/mysql/

 

I installed all three of the files inside:

 

- mysql-5.5.8-osx10.6-x86_64.pkg

- MySQLStartupItem.pkg

- MySQL.prefPane

 

They all installed fine but in the Preference Pane when trying to start MySQL nothing happens (after asking for my password)

If i try starting MySQL via termal using - sudo /usr/local/mysql/support-files/mysql.server start

 

I get this error:

"/usr/local/mysql/support-files/mysql.server: line 256: my_print_defaults: command not found

Starting MySQL

ERROR! Couldn't find MySQL server (./bin/mysqld_safe)"

 

I have heard you need xcode but i do not have this installed.

Please can someone help me to get MySQL running.

 

Thank you

[eli312]

Im guessing no one has ever had this problem before? 

 

I have uninstalled around 10 times i have installed both

 

- Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive

- Mac OS X 10.5 (x86, 64-bit), DMG Archive

 

Both do not start.

 

I have gone though many "fix's" none have done anything, it will still not start.

 

Is there a problem with snow leopard? Is there a fix?

Please help sorry if i sounding desperate but i am.

 

Thank you

Eli

[eli312]

Well i got it working.

 

I shall explain how.

 

I found the fix here:

http://bugs.mysql.com/bug.php?id=53232 (in the comments)

also here http://bugs.mysql.com/bug.php?id=55530

 

But it took me a while to understand so i try to explain it easier.

Open Terminal and enter the following:

 

sudo nano /usr/local/mysql/support-files/mysql.server

 

This will open up the mysql.server file used to start up MySQL.

Then press ctrl + W to search for type in 'basedir=.' (with out the quotes)

 

Once you have found this line change it from:

 

basedir=.

 

To

 

basedir=/usr/local/mysql

 

Next search for 'mysqld_pid_file_path=$datadir/`hostname`.pid' (with out the quotes)

 

Again change it from:

 

mysqld_pid_file_path=$datadir/`hostname`.pid

 

To

 

mysqld_pid_file_path=$datadir/`/bin/hostname`.pid

 

Thats all the changes you need to make press ctrl + X and save the changes.

You might want to restart you computer for the effects to take places.

 

I then got a problem with MySQL not wanting to start up automatically but i fixed this here:

 

http://discussions.apple.com/thread.jspa?messageID=12796285

 

sudo chown -R root:wheel /Library/StartupItems/MySQLCOM

(although i cannot now turn it off but thats not such a big problem)

 

Hope this helps anyone out there with this problem. Sorry that it is a little long