MySQL Forums
Forum List  »  Install & Repo

Advanced Search
New Topic

Trying to move Mysql to a new OS X (High Sierra) machine: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Posted by: Mike Levin
Date: May 27, 2018 04:04AM

I had MySQL working perfectly on my Apple OS X 10.11 system. I upgraded to High Sierra and noticed that the mysql directories did not come over during the Migration process. So I copied the directory manually in terminal. Then it complained about ownership, so I set ownership to _mysql. Now it won't start, and the last bit of the .err file says:

Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

what is the right way to make this work?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Trying to move Mysql to a new OS X (High Sierra) machine: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Mike Levin
May 27, 2018 04:04AM
Re: Trying to move Mysql to a new OS X (High Sierra) machine: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Terje Røsten
May 27, 2018 09:28AM


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.