MySQL Forums :: Install & Repo :: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist


Advanced Search

Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Posted by: Syed muhammad ali naqvi ()
Date: July 01, 2006 03:14PM

Hello Friend,
You can easily overcome this problem by removing the data directory before taking the backup of data if you have already have important data.
rm -rf /pathtodatadir
then
cd /usr/local/mysql1/bin
./mysql_install_db --user=mysql --ldata=/sqldata
./mysqld_safe --datadir=/sqldata --user=mysql &


I hope this will solve ur problem


Regards,
Turab

Options: ReplyQuote


Subject Written By Posted
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Martin Quinn 10/25/2005 12:34AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist David Takle 11/16/2005 06:33PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Syed muhammad ali naqvi 07/01/2006 03:14PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Adrian Boyd 12/10/2007 03:46PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Martin Du Plooy 03/16/2009 02:04AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Harold Clark 03/22/2006 11:27AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Gattu Sevalkar 04/04/2007 06:45AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist marko.skarica 04/05/2006 04:24PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Bill Karwin 04/05/2006 06:06PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist marko.skarica 04/05/2006 10:01PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist marko.skarica 04/05/2006 10:12PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist marko.skarica 04/05/2006 10:39PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist marko.skarica 04/06/2006 06:22PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Bill Karwin 04/06/2006 06:26PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Andre Zandberg 05/26/2006 03:01PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Walter Bays 03/18/2007 04:24PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Patrick Crews 01/27/2009 11:23AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Joe Rasberry 04/21/2006 06:52AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Joe Rasberry 04/21/2006 07:10AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Adam Peterson 04/02/2007 06:52AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist cchan 05/19/2006 02:48PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Jay Suttiruttana 06/01/2006 04:25PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Jonathan Handler 06/23/2006 09:54AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Harry Kim 08/04/2006 10:15AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist John Smrekar 10/02/2006 12:44PM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Paul Nguyen 06/11/2007 01:28AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist mail1095613 07/16/2007 06:35AM
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Patrick Crews 01/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.