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

Print Friendly, PDF & Email

If you get the error described in the heading, you can overcome this problem by doing the following

Be sure to change the path’s to reflect your own setup

rm -rf /pathtodatadir
then
cd /usr/local/mysql1/bin
./mysql_install_db --user=mysql --ldata=/sqldata
./mysqld_safe --datadir=/sqldata --user=mysql &;

I go this solution from this page.

Cheers

Share and Enjoy !

0Shares
0 0 0

3 comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.