mySQL permissions error after 10.1.5 update

Jun 13, '02 09:12:21AM

Contributed by: Anonymous

I had an odd MySQL problem when I installed the 10.1.5 update. One of my databases was giving me this error when I tried to select it:

 mysql> use dbname
Can't read dir of './dbname/' (Errcode: 13)
Database changed
It turns out that the permissions for the database were somehow changed. To correct it, enter the following in the Terminal:
 %cd /usr/local/mysql/data/
% sudo chmod u=rwx,g=rx,o= dbname
Replace dbname with the name of the database, and you'll need to be an Admin user to execute the command 'sudo' command. That should clear everything up.

Comments (1)


Mac OS X Hints
http://hints.macworld.com/article.php?story=200206130912213