Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
For example :====
/usr/local/mysql-5.5.28-linux2.6-x86_64/bin/mysqld_safe
--defaults-file=/etc/my.cnf &
$$**************Posted by Shishir Tekade**********$$
Continuing with the MySQL mini posts I ran into this error today while setting up our redundancy servers. I moved the mysql directory out of it’s default location of /var/lib. So when I went to start Mysql it would fail. When I looked in the /var/log/mysqld.log I seen the following:
Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
To fix this issue you simply just have to tell mysql where to look not that the default installation is moved. You can do that with:
mysql_install_db –user=mysql –ldata=/newlocation
once you do that you can restart mysql
/etc/init.d/mysqld restart
For example :====
./mysql_install_db -user=mysql
-ldata=/usr/local/mysql-5.5.28-linux2.6-x86_64/data
--basedir=/usr/local/mysql-5.5.28-linux2.6-x86_64
$$**************Posted by Shishir Tekade**********$$
No comments:
Post a Comment