MySQL connectivity Access Denied Problem - MySQL

[drummer]

..NET 1.1 - C#
MySQL 4.0.1
MySQL Connector/NET 1.0

Trying to get my .NET 1.1 web app to prod environment on 3rd party web
host(no access to windows, but real decent tools to help manage alot of
windows tasks - IXWebHosting).

My aspx pages come up fine. When I click a button to pull data from the
MySQL DB and populate the screen I get:

[MySqlException: Access denied for user: 'user12.34.123.1' (Using
password: YES)]

Now, from my laptop, I am able to connect to the DB on the 3rd party
site and pull data with the same useID and PW that I am trying to get
data with in my web app.

Here are the grants for the user:

GRANT USAGE ON *.* TO 'user''%' IDENTIFIED BY PASSWORD
'111672c122357e0f'
GRANT ALL PRIVILEGES ON 'db`.* TO 'user''%'

If I can connect from my laptop, why can I not connect from the IIS web
server on the 3rd Party Host?

[Alex Buell]

On 3 Jun 2006 23:01:05 -0700, I waved a wand and this message magically
appeared from drummer:

> If I can connect from my laptop, why can I not connect from the IIS
> web server on the 3rd Party Host?

Check firewall on 3rd party host. It's probably not letting you connect
to it from outside.
--
[url]http://www.munted.org.uk[/url]

Take a nap, it saves lives.

[drummer]

Why would the firewall let me connect (using command line mysql) from
my home to the mysql DB deep inside their fortress, but it won't let me
connect from the IIS server to their MySQL DB which are probably
sitting side by side?

Alex Buell wrote:

> On 3 Jun 2006 23:01:05 -0700, I waved a wand and this message magically
> appeared from drummer:
>

> > If I can connect from my laptop, why can I not connect from the IIS
> > web server on the 3rd Party Host?

>
> Check firewall on 3rd party host. It's probably not letting you connect
> to it from outside.
> --
> [url]http://www.munted.org.uk[/url]
>
> Take a nap, it saves lives.

[Alex Buell]

On 4 Jun 2006 05:10:43 -0700, I waved a wand and this message magically
appeared from drummer:

> Why would the firewall let me connect (using command line mysql) from
> my home to the mysql DB deep inside their fortress, but it won't let
> me connect from the IIS server to their MySQL DB which are probably
> sitting side by side?

No, I misread your query. I still think you should check all the
firewalls on both PCs. Make sure they're all using the same port
addresses.
--
[url]http://www.munted.org.uk[/url]

Take a nap, it saves lives.

[ZoombyWoof]

drummer wrote:

> .NET 1.1 - C#
> MySQL 4.0.1
> MySQL Connector/NET 1.0
>
> Trying to get my .NET 1.1 web app to prod environment on 3rd party web
> host(no access to windows, but real decent tools to help manage alot of
> windows tasks - IXWebHosting).
>
> My aspx pages come up fine. When I click a button to pull data from the
> MySQL DB and populate the screen I get:
>
> [MySqlException: Access denied for user: 'user12.34.123.1' (Using
> password: YES)]
>
> Now, from my laptop, I am able to connect to the DB on the 3rd party
> site and pull data with the same useID and PW that I am trying to get
> data with in my web app.
>
> Here are the grants for the user:
>
> GRANT USAGE ON *.* TO 'user''%' IDENTIFIED BY PASSWORD
> '111672c122357e0f'
> GRANT ALL PRIVILEGES ON 'db`.* TO 'user''%'
>
> If I can connect from my laptop, why can I not connect from the IIS web
> server on the 3rd Party Host?
>

Im not 100% sure about this, but if the IIS web server resides on the
same host as the database, you will need to define a grant to 'user' on
localhost as well. If this is not done, mysql will not use the grant
that says % because the connection comes from localhost and it will use
some default account that will not have access to your database.

As I said, I'm not 100% on this, but 95 maybe :-)

/ZW