0

Today I upgraded from Leopard (10.5) to Snow Leopard (10.6). After upgrading MySQL wouldn't start so I downloaded MySQL 5.5.8 (64bit) dmg. I installed MySQL, Startup Item and PrefPane.

After this I tried to 'Start mySQL Server' from System Preferences but nothing happens. The Server instance remains at stopped.

Does anybody have any advice for fixing this and getting MySQL up and running again?

I'm not a developer so I'm not even sure where to begin when trying to debug this. Any advice is much appreciated.

random
  • 9,774
  • 10
  • 66
  • 83
Lee
  • 35
  • 1
  • 1
  • 4

1 Answers1

1

I would start by opening Console and monitoring the System Log while attempting to start MySQL. And also mysql error log, wherever you have configure it to be.

Remus Rusanu
  • 288,378
  • 40
  • 442
  • 569
  • Thanks Remus.28/12/2010 12:18:16 [0x0-0x4e04e].com.apple.systempreferences[2662] /usr/local/mysql/support-files/mysql.server: line 256: my_print_defaults: command not found – Lee Dec 28 '10 at 12:18
  • Couldn't find the mysql error log anywhere. If I open usr/local the folder "mysql-5.5.8-osx10.6-x86_64" is definitely there – Lee Dec 28 '10 at 12:28
  • Look into that mysql.server script and see what is on line 256 and why does it expect my_print_defaults to be in the path. As an alternative, you can give MAMP a try, since that comes with a full stack (apache, php, mysql) preconfigured in a Mac package. – Remus Rusanu Dec 28 '10 at 16:20
  • This fixed it in the end http://www.artin.org/geekblog/2010/12/installing-mysql-5-5-8-on-mac-os-x-snow-leopard/ had to set basedir and datadir – Lee Dec 28 '10 at 23:06