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
    Commented Apr 26, 2011 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). Commented Apr 26, 2011 at 10:21
  • Check /var/log for mysql related logs and start trudging through them until you see some errors. Commented Apr 26, 2011 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
    Commented Apr 27, 2011 at 5:11
  • @Rene: Mysql 5.5.11 (64 bit version) running here on Leopard (binary downloaded from mysql site) quite happily.
    – nimrodm
    Commented Apr 27, 2011 at 20:08

1 Answer 1


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 .