I'm getting this error while trying to start the mysql server

$ sudo mysqld_safe --user=mysql
110425 23:11:33 mysqld_safe Logging to '/usr/local/mysql/data/unknown-e0-f8-47-0c-04-a0.lan.err'.
110425 23:11:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
110425 23:11:35 mysqld_safe mysqld from pid file /usr/local/mysql/data/unknown-e0-f8-47-0c-04-a0.lan.pid ended

any suggestions?

  • There is no error there - what does the log say? – mmmmmm Apr 26 '11 at 7:42
  • Which version of MySQL ?? v5.5.11 doesn't work (can't start) on Snow Leopard, but the old v5.1.56 do work (can start). – Rene Larsen Apr 26 '11 at 10:21
  • Check /var/log for mysql related logs and start trudging through them until you see some errors. – ConstantineK Apr 26 '11 at 11:39
  • 1
    Could you please dump contents from /usr/local/mysql/data/unknown-e0-f8-47-0c-04-a0.lan.err? Looks like an error related to ethernet address binding, I guess. – Ngoc Pham Apr 27 '11 at 5:11
  • @Rene: Mysql 5.5.11 (64 bit version) running here on Leopard (binary downloaded from mysql site) quite happily. – nimrodm Apr 27 '11 at 20:08

Change skip-locking to skip-external-locking in /etc/my.cnf. This problem can happen if you had a different MySQL installed previously. I experienced this problem when I moved to MAMP.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .