Mac MySQL data folder access denied

Question

My MySQL data directory is located at /usr/local/mysql/data When I view it in finder I get this:

When I try to open the data folder I get an access denied error.

Via the terminal I can execute the command sudo cd /usr/local/mysql/data without errors, yet I don't enter the data directory. ls gives back the contents of my root dir.

The same bevahiour occurs with the command sudo cd /usr/local/mysql/data/firma ("firma" is a existing database name)

However when I write some nonsense instead of "firma", it gives me an error, thus I'm in the correct directory. I can also view the file size of said firma directory / file.

How can I view all the files in the data directory?

Lashawn

What have you tried so far to change permissions? discussions.apple.com/thread/4171806 or forums.macrumors.com/threads/… or discussions.apple.com/thread/1823050 – Acetabulum

Could solve it by chaning the permissions. In hindsight I don't know why I haven't thought of this myself haha. Thanks a lot! – Lashawn

Answer 1

Right click on the folder and click on Get Info item in the context menu. In the window displayed click on the lock icon at the bottom, and select Read & Write privilege for everyone.

Waly