If you have not installed MySQL before, you must create the MySQL grant tables:
shell> scripts/mysql_install_db --user=mysql Keith In theory, theory and practice are the same; In practice they are not. On Tue, 14 Feb 2006, Ravi Kumar wrote: > To: Imran Chaudhry <[EMAIL PROTECTED]> > From: Ravi Kumar <[EMAIL PROTECTED]> > Subject: Re: Installation Issue > > Imran, > I noticed couple of permissions were not correct.I changed mysql.mysql. > Still Ihave been getting following errors. > 060214 15:53:05 mysqld started > 060214 15:53:05 InnoDB: Started; log sequence number 0 43655 > 060214 15:53:06 [ERROR] Fatal error: Can't open and lock privilege tables: > Table 'mysql.host' doesn't exist > 060214 15:53:06 mysqld ended > > Please advice. > thanks > > Imran Chaudhry <[EMAIL PROTECTED]> wrote: > On 2/14/06, Ravi Kumar wrote: > > Starting mysql with root.I tried withn mysql user account also but still > > same error. > > thanks > > Ravi, > Assuming you are starting MySQL with mysqld_safe, then it will invoke > the MySQL server as the mysql user. > > I suspect the cause is that /var/lib/mysql is not owned by mysql > > If so, as superuser: chown -R mysql:mysql /var/lib/mysql > > Regards, > Imran Chaudhry > -- > http://www.ImranChaudhry.info > MySQL Database Management & Design Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
