6 responses to “MySQL won’t start on Snow Leopard”

• 

  Robert Rowe January 5th, 2011 at 08:12

  I finally gave up on the packages from the Oracle team and loaded MAMP. Everything works beautifully; MySQL, Apache, and PHP.

• 

  Funny Pugs January 6th, 2011 at 18:52

  I just started up my laptop again, and after all the stuff I did above, again I get the dreaded:

  ERROR 2002 (HY000): Can’t connect to local MySQL server through socket
  ‘/tmp/mysql.sock’ (2)

  MySQL wasn’t running.

  So it must not be launching at boot.

  Rats. Where’s mysqld_safe again?

  locate mysqld_safe
  …
  ln -s /usr/local/mysql-5.1.54-osx10.6-x86_64/bin/mysqld_safe ~/mysqld_safe
  sudo mysqld_safe –user=root

  Command-T opens a new terminal.

  mysql -u root -p

  ERROR 2002 (HY000): Can’t connect to local MySQL server through socket
  ‘/tmp/mysql.sock’ (2)

  WTH?!

  So I tried

  mysql –help

  which said, in part,

  socket (No default value)

  So I tried

  mysql -u root -p –socket=/var/mysql/mysql.sock

  Access denied to ‘root’@'localhost’ (using password=YES)

  mysql –socket=/var/mysql/mysql.sock -u root

  Worked. Note to self: change (add) a root password.

  I’m guessing now I can put /var/mysql/mysql.sock into /private/etc/my.cnf …

  So I do

  sudo vi /private/etc/my.cnf

  It already has a config group for mysqld (but not mysqld_safe…)

  So I add

  [mysqld_safe]
  socket=/var/mysql/mysql.sock

  and save it.

  On a whim, I try

  cd ~
  mysqld_safe -u root

  worked.

  Then I ps aux | grep mysql, find the process id and sudo kill 977
  Another ps aux | grep mysql shows its not running anymore.

  Now I do

  mysqld -u root

  worked (terminal has different output)
  sudo mysqld -u root
  110104 20:09:57 [Warning] Setting lower_case_table_names=2 because
  file system for /usr/local/mysql-5.1.54-osx10.6-x86_64/data/ is case
  insensitive
  110104 20:09:57 [Note] Plugin ‘FEDERATED’ is disabled.
  110104 20:09:57 InnoDB: Initializing buffer pool, size = 8.0M
  110104 20:09:57 InnoDB: Completed initialization of buffer pool
  110104 20:09:57 InnoDB: Started; log sequence number 0 45289556
  110104 20:09:57 [Note] Event Scheduler: Loaded 0 events
  110104 20:09:57 [Note] mysqld: ready for connections.
  Version: ’5.1.54′ socket: ‘/var/mysql/mysql.sock’ port: 3306 MySQL
  Community Server (GPL)

  mysql -u root

  ERROR 2002 (HY000): Can’t connect to local MySQL server through socket
  ‘/tmp/mysql.sock’ (2)

  So I again do

  sudo vi /private/etc/my.cnf

  and add

  [mysql]
  socket=/var/mysql/mysql.sock

  and save it.

  mysql -u root

  worked.

  Now /private/etc/my.cnf looks like this:

  [mysqld]
  socket=/var/mysql/mysql.sock

  [mysqld_safe]
  socket=/var/mysql/mysql.sock

  [mysql]
  socket=/var/mysql/mysql.sock

  Pref pane still shows it as stopped and does nothing useful.

  Whatever.

  Hope it helps someone.

• 

  Funny Pugs January 6th, 2011 at 18:58

  The saga continues. I found this forum thread helpful, as well as the Apple support discussion link:

  http://www.phpfreaks.com/forums/mysql-help/mysql-will-not-start-snow-leopard-10-6-5/

• 

  Tom Reitz January 17th, 2011 at 15:30

  Do this: http://forums.mysql.com/read.php?11,399397,399606#msg-399606 the pref pane now works for me.

• 

  phpguru January 25th, 2011 at 19:49

  My laptop had to go back into the shop again and I’m now on a loaner Macbook (slow!) and I can’t use sudo mysqld_safe -u root anymore. When I try I get MacbookPro:~ me$ sudo mysqld_safe -u root
110125 19:42:03 mysqld_safe Logging to '/usr/local/mysql/data/MacbookPro.local.err'.
110125 19:42:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
110125 19:42:03 mysqld_safe mysqld from pid file /usr/local/mysql/data/MacbookPro.local.pid ended
MacbookPro:~ me$
however this works: sudo mysqld -u root

• 

  Brian Wrightson April 3rd, 2012 at 07:59

  This helped a bunch – thanks!!