Installing MySQL on Win2000

[Guest_imported]

I downloaded mysql-max-3.23.49-win.zip from the server, ran the setup and install it into c:\mysql and create the my.ini file in c:\winnt\. I then try to run mysql and it give me the following error message. Could someone tell me what I need to do for it to work? Thanks

Hung-Hsun Su

c:\mysql\bin\mysql
ERROR 2003: Can't Connect to MYSQL server on 'localhost' (10061)

c:\mysql\bin\mysqladmin -u root shutdown
MYSQLADMIN: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost'
Check that mysqld is running on localhost and that th
You can check this by doing 'telnet localhost 3306'

and i got this message in the mysql.err file
020223 0:01:55 MYSQLD-MAX-NT: Table 'mysql.host' doesn't exist

 

[Guest_imported]

n/m, i figured out the problem I have.

 

[jmpurser]

Would you please share your solution? I'm having the same problem.

Thanks,

John

 

[Guest_imported]

I am not sure if this applies to you, but I've change the datadir of MySQL to point to c:/Inetpub/Database instead of the original c:/mysql/data. After trying out various thing, I found that besides modify your my.ini to have datadir point to your new directory, you need also to copy the mysql folder to the new location. Apparently this is the main DB that mysql use when start up. I also used WinMySQLAdmin tool to generate my.ini, but I don't think that is where the problem lies because I manually modify it to resemble the one I created and it run just fine. Hope this helps.

Hung-Hsun Su