File './mysql-bin.index' not found on MySql startup on OSX 10.5

mysql mysql-management osx-leopard
tintin picture tintin · Aug 8, 2011 · Viewed 13.1k times · Source

I did a manual setup for the installation of MySql 5.5 on mac OSX 10.5 instead of using .dmg package installer. After following all the installation steps when I started the sql server with sudo mode I got the following error and the server did not start.

/usr/local/mysql/bin/mysqld: File './mysql-bin.index' not found (Errcode: 13)
110808 21:22:12 [ERROR] Aborting

I cannot find ./mysql-bin.index file anywhere in my /usr/local/msql directory.

Can anyone tell how to get around this problem? Thanks.

Answer

van hong picture van hong · Jul 18, 2012

I think the problem is permissions of this folder /usr/local/msql. Change the permissions with:

chown -R mysql /usr/local/msql

Then restart the MySQL server.

Related questions

ERROR 1396 (HY000): Operation CREATE USER failed for 'jack'@'localhost'

I seem to be unable to re-create a simple user I've deleted, even as root in MySQL. My case: user 'jack' existed before, but I deleted it from mysql.user in order to recreate it. I see no vestiges of …

Read More
How to set root password to null

How can I change the password for root user of MySQL to null -- meaning no password or '' -- from the MySQL command line client?

Read More
mysql command for showing current configuration variables

Can not find a command that displays the current configuration of mysql from within the database. I know I could look at /etc/mysql/my.cnf but that is not what I need.

Read More