MySql on Windows Server 2003

------_=_NextPart_001_01C5947C.822CA669
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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.=20

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

=20

------_=_NextPart_001_01C5947C.822CA669--

Re: MySql on Windows Server 2003

While you have the skip-grant-tables in effect, add a grant for your user at
127.0.0.1. This is a 5.0.10 issue that is resolved in 5.0.10a.

Mike


sjanusik@micron.com wrote:
> 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
>
>
>

--
Mike Hillyer, Technical Writer
Lethbridge, Alberta, Canada
MySQL AB, www.mysql.com


"The Open Source movement has become a major force across the software industry,
and MySQL is the world's most popular open source database."
--Fortune Magazine

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: MySql on Windows Server 2003

I downloaded 5.0.10a and have successfully installed and configured it.
Thank you for your support!
-Steve=20

-----Original Message-----
From: Mike Hillyer [mailto:mhillyer@mysql.com]=20
Sent: Monday, August 01, 2005 9:20 AM
To: sjanusik
Cc: win32@lists.mysql.com
Subject: Re: MySql on Windows Server 2003

While you have the skip-grant-tables in effect, add a grant for your
user at 127.0.0.1. This is a 5.0.10 issue that is resolved in 5.0.10a.

Mike


sjanusik@micron.com wrote:
> Good Day,
> I am having an issue accessing MySql (4.1 & 5.0) on Windows Server=20
> 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=20
> 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=20
> this MySQL ver"
>=20
> This install runs fine on my Windows XP system.=20
>=20
> 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=20
> normally.
>=20
> I get the same error.
>=20
> I have this loaded on a VM session, for easy reloading. Please let me

> know if you have suggestions.
>=20
> Regards,
> -Steve
>=20
> =20
>=20

--
Mike Hillyer, Technical Writer
Lethbridge, Alberta, Canada
MySQL AB, www.mysql.com


"The Open Source movement has become a major force across the software
industry,=20
and MySQL is the world's most popular open source database."
--Fortune Magazine

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org