Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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?

share|improve this question
    
There is no error there - what does the log say? –  Mark 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. –  hobs 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
show 2 more comments

1 Answer

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.