MySQL Forums
Forum List  »  Install & Repo

Advanced Search
New Topic

Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Posted by: Joe Rasberry
Date: April 21, 2006 06:52AM

Installed mysql on Solaris machine. Created a symbolic link /usr/local/mysql pointing to the installation directory. Tried to start mysqld_safe and received and a error message on startup "Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist".

Solution:

Created an /etc/my.cnf with the following:

[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data

This cured the startup problem

Navigate: Previous Message• Next Message
Options: Reply• Quote


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