MySQL Forums
Forum List  »  Install & Repo

Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Posted by: Patrick Crews
Date: January 27, 2009 11:22AM

You need to pass two extra parameters to mysql_install_db (especially on Solaris via the .pkg system).

Try scripts/mysql_install_db --datadir=<path_to_datadir> --basedir=<path_to_mysql_installation> --user=mysql

This worked for me where
<path_to_datadir> = /opt/mysql/mysql/data (the default)
<patch_to_mysql_installation> = /opt/mysql/mysql (also default)

Change these as needed to reflect your setup.

After this, you should be able to to start the server per the manual.

Options: ReplyQuote


Subject
Written By
Posted
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
January 27, 2009 11:22AM


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.