MySql on Windows Server 2003 - sjan...@micron.com - com.mysql.lists.win32

3 messages in com.mysql.lists.win32MySql on Windows Server 2003

From	Sent On	Attachments
sjan...@micron.com	29 Jul 2005 13:31
Mike Hillyer	01 Aug 2005 08:19
sjan...@micron.com	01 Aug 2005 09:12

Subject:	MySql on Windows Server 2003
From:	sjan...@micron.com (sjan...@micron.com)
Date:	07/29/2005 01:31:11 PM
List:	com.mysql.lists.win32

Good Day, I am having an issue accessing MySql (4.1 & 5.0) on Windows Server 2003, please respond if you have done this successfully. I have successfully loaded MySql, and the service starts successfully. This is on a clean Windows Server 2003 installations. ( No other software installed) When I attempt to use MySql.exe it errors with the following message: "Error 1130 (HY000): Host '127.0.0.1' is not allowed to connect to this MySQL ver"

This install runs fine on my Windows XP system.

During troubleshooting I have found that if I manually start the service "Mysqld.exe --Skip-Grant-Tables" then I am able to authenticate. I then Grant root all available privs and then restart the service normally.

I get the same error.

I have this loaded on a VM session, for easy reloading. Please let me know if you have suggestions.

Regards, -Steve