List:MySQL on Win32« Previous MessageNext Message »
From:Peter Monk Date:December 6 2004 12:44am
Subject:Re: Cannot connect to mysql after install....
View as plain text  
Ola One wrote:

> Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

> c:\program files\mysql41\bin>mysql -u root mysql
> ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

Ola,

Have you changed the location for mysql data files? (with a datadir=C:\<some path>
command in your my.ini/my.cnf file)

mysql.host is a table created in your database for MySQL's own use.
If it can't find it, either you've specified a new data file path and
not moved the files to the new location, or there was some kind of problem
during installation and the data files weren't created.


-- 
Peter Monk ~ IT Department
United Water International

Phone ....... 08 8301 2736
Fax ......... 08 8357 9728
Mobile ...... 0410 487 723
Thread
Cannot connect to mysql after install....Ola One5 Dec
  • Re: Cannot connect to mysql after install....Peter Monk6 Dec