Ok, I found the cause which caused the problem. I wiped out the whole installation directory but the c:\my.cnf file was modified incorrectly. Sine I would like to use innoDB, I had to created database subdirectories manually. I did that but I specified datadir by mistake:
datadir = e:/mysql411/database it should be: datadir = e:/mysql411/data I misunderstood the value of datadir in the my.cnf file. Anyway, thanks for your kindly support. Michael Wu [EMAIL PROTECTED] -----Original Message----- From: Robert J Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 5:46 PM To: MICHAEL_WU Cc: [EMAIL PROTECTED] Subject: Re: FW: Could not start MySQL after reinstall - Can't open privilege tables: Table 'mysql.host' doesn't exist Did you change the permissions for the files to include read/write/change for the user/account MySQL uses on your system? This doesn't require deleting, as far as I recall Windows permissions... Oh, can you verify that the file host under directory mysql DOES exist? If so, it's really most likely a permissions problem. MICHAEL_WU wrote: >Since the database I created was not critical, I could simply throw it away. >Therefore, >delete the whole MySql installation directory and unzip the alpha release >zip file again >to create the installation directory tree. However, the following error >persists: > > Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't >exist > >Everything should be wiped out I thought. Does MySQL saves some data >somewhere other than >the installation directory? More help, please? >Michael Wu > >-----Original Message----- >From: Robert J Taylor [mailto:[EMAIL PROTECTED] >Sent: Thursday, May 27, 2004 4:52 PM >To: "michael_wu[¡±d¡±?1F]" >Cc: [EMAIL PROTECTED] >Subject: Re: Could not start MySQL after reinstall - Can't open privilege >tabl es: Table 'mysql.host' doesn't exist > > >Check permissions on the mysql\data directory and files/folders below >for the MySQL process/user (sorry for not knowing the right Windows >terminology, I'm not a Windows user). > >HTH, > >Robert J Taylor >[EMAIL PROTECTED] > >michael_wu[§d§»¹F] wrote: > > > >>Hello, >> I run into a problem after re-installing mySQL 4.1.1 today. When I >>tried to start the service on my Windows2K, I got the following error: >> >> 040527 15:37:49 Fatal error: Can't open privilege tables: Table >>'mysql.host' doesn't exist >> >> Can some one tell me how to solve the problem? >> >>Thanks in advance! >>Michael Wu >> >> >> >> >> > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
