Here's the situation homies. I had recently reinstalled OS 10.4 due to the problems I had with Tiger on my G4 Powerbook. I had a MySQL server running and needed to get it back online to get some work done. So I pulled down the latest binary release for Mac (5.0.27 as of the time of this writing). Installation went nary a hitch and after getting the datadir correct, I was able to make a client connection to the server. Enter the problem - I could show databases/tables but any query would return:
ERROR 1017 (HY000): Can't find file: './db/table.frm' (errno: 13)
Thankfully this post lead me to the solution, permissions d'oh!
computer$ perror 13
OS error code 13: Permission denied
Sure enought, the MYD, MYI and frm files of the database were owned by root with permission 640. Changing ownership to the mysql user brought the warm fuzzy. perror is your friend in the mix.
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment