On Windows machines you do not need to init the mysql db as it is pre-initialized. But, if you installed MySQL a directory other than C:\mysql there is additional work that has to be done. You have to create either a C:\my.cnf OR <windows-system-dir>\my.ini file with the following settings (example shows an install in D:\pgms\mysql):
[mysqld] basedir=D:/pgms/mysql datadir=D:/pgms/mysql/data And yes, you need to use forward slashes and not backslashes. I'm not sure if the exclusion of this config info will give you the error you are getting, but I suspect it may. Lastly, I've read on other forums that MySQL doesn't like install locations with spaces in the path (such as the famous "C:\Program Files") - I don't know if that is true or not, but thought it may be worth mentioning. Hope that helps, Mark --- Simon Green <[EMAIL PROTECTED]> wrote: > On UNIX you need to run a creat datbase using > scripts/mysql_install_db > > Simon > > -----Original Message----- > From: Larry Wasserman > [mailto:[EMAIL PROTECTED] > Sent: 20 October 2003 16:30 > To: [EMAIL PROTECTED] > Subject: Starting the mySQL Server > > > I cannot start the MySQl Server. I am running > Windows XP. I checked the > error file and get the following message. > > 031020 10:11:56 InnoDB: Started > 031020 10:11:56 Fatal error: Can't open privilege > tables: Table > 'mysql.host' doesn't exist > 031020 10:11:56 Aborting > > What do I need to do for my mysql.hosts file? > Where should it be located? > > _________________________________________________________________ > > Larry Wasserman Two > Prudential Plaza > Enterprise Marketing Automation 180 North > Stetson, Suite 5200 > SAS Institute Inc. > Chicago, IL 60601 > > <<mailto:[EMAIL PROTECTED]>> Phone: > 312-819-6800 x8826 > Pager Phone: 888-446-6597 Fax: 312-240-0342 > > SAS ... The Power to Know __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
