osx mysql not working after a reboot

First and foremost, I am using Lion and running all latest updates as of today.

I restarted my desktop system over the weekend as a usual practice. Then this morning I realized my local website isn’t working. Further tracking leads to MySQL not starting successfully. You can see the red text in the MySQL System Preference. Clicking on “Start MySQL Server” won’t help.

At this point, ask yourself if you are using my.cnf. Usually, you don’t have to. But if you ever need to do any customization, you probably have copied this file over to /etc. If this applies to you, keep reading. Otherwise this fix may not apply to you.

Do a “sudo mysqld_safe”. You will see something like the following:

my_osx:/tmp bchan$ sudo mysqld_safe
110926 11:08:31 mysqld_safe Logging to '/usr/local/mysql/data/my_osx.err'.
110926 11:08:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
110926 11:08:32 mysqld_safe mysqld from pid file /usr/local/mysql/data/my_osx.pid ended

Opening up the error file “/usr/local/mysql/data/my_osx.err” will give you a clue.

110926 11:22:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
110926 11:22:53 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
/usr/local/mysql/bin/mysqld: File './mysql-bin.index' not found (Errcode: 13)
110926 11:22:53 [ERROR] Aborting

110926 11:22:53 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

110926 11:22:53 mysqld_safe mysqld from pid file /usr/local/mysql/data/my_osx.pid ended

We caught it. It’s this: “/usr/local/mysql/bin/mysqld: File ‘./mysql-bin.index’ not found (Errcode: 13)

What the heck is “mysql-bin.index“? Yea, whatever, I never asked for it. Now, open up your /etc/my.cnf file, search for “log-bin=mysql-bin” and “binlog_format=mixed“, then comment them out.

# Replication Master Server (default)
# binary logging is required for replication

# binary logging format - mixed recommended

If you really want to enable this whatever you call it, read more at: http://www.linuxquestions.org/questions/linux-software-2/mysqld-var-log-mysql-mysql-bin-index-not-found-480676/

Also, uncomment the InnoDB lines if you are using InnoDB tables.

Then now, restart your osx. Yup, restart your osx. Then hopefully MySQL will start successfully at startup.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s