Re: Trying to open db from 5.5.10 in new 5.5.17 install
Posted by: Rick James
Date: November 15, 2011 09:41PM

(This belongs in the Install forum.)

Drop down to a "terminal" or commandline interface in OSX. You will be in Un*x. Now find out the ownership on the files and directories. They need to be owned by "mysql".

THE FOLLOWING IS APPROXIMATE:
cd /..../mysql/
ls -ld # see who owns mysql and with what permissions. You want to see
drwxrwx--- mysql mysql
The initial drwx, and the first "mysql" are important.
ls -l # check the files there. Directories (such as "data") should have the same drwx and mysql.
ls -lR # This will spit out a lot of stuff -- all the files underneath (R=Recursive). Directories should be as above; files should be
-rw-rw---- mysql mysql

If they are owned by someone else, fix them:
cd /..../mysql/
chown -R mysql *
(Probably the permissions will be ok.)

Options: ReplyQuote


Subject
Written By
Posted
Re: Trying to open db from 5.5.10 in new 5.5.17 install
November 15, 2011 09:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.