MySQL server RPM installation did not create mysql database in non-default datadir, Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
(Doc ID 1593336.1)
Last updated on MARCH 10, 2020
Applies to:MySQL Server - Version 5.1 to 5.6 [Release 5.1 to 5.6]
An error message is received when trying to start the MySQL server: Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
The authoritative location of the my.cnf has moved from /etc/my.cnf to /usr/my.cnf for the MySQL 5.6 version.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document