MySQL Forums
Forum List  »  Install & Repo

Apparent permissions mess upgrading from 5.5 to 5.6
Posted by: Rob Lewis
Date: August 15, 2016 01:13PM

Trying to upgrade MySQL 5.5 to 5.6 (as a stop along the way to 5.7) under OS X Server 10.11.

I have somehow ended up with mixed permission settings. For example, in the /data directory, many files have owner root and group _mysql. Others have both owner and group as _mysql. In the main MySQL install directory, all files and directories are root:wheel except the data directory, which is _mysql:_mysql.

When I try to start mysqld, it says "Can't create test file ...lower-test" and "File './mysql-bin.index' not found (Errcode: 13 - Permission denied)" then aborts.

How can I fix this?

(Also, when mysqld is starting it warns:
'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
and:
TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option
What are these about? I have the thread concurrency stuff commented out in my.cnf.)

Options: ReplyQuote


Subject
Written By
Posted
Apparent permissions mess upgrading from 5.5 to 5.6
August 15, 2016 01:13PM


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.