Professional Web Applications Themes

MySQL connectivity Access Denied Problem - MySQL

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

  1. #1

    Default MySQL connectivity Access Denied Problem

    ..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?

    drummer Guest

  2. #2

    Default Re: MySQL connectivity Access Denied Problem

    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 Guest

  3. #3

    Default Re: MySQL connectivity Access Denied Problem

    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.
    drummer Guest

  4. #4

    Default Re: MySQL connectivity Access Denied Problem

    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.
    Alex Buell Guest

  5. #5

    Default Re: MySQL connectivity Access Denied Problem

    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
    ZoombyWoof Guest

Similar Threads

  1. contribute problem - access denied file may not existpermission problem
    By Al1973 in forum Macromedia Contribute Connection Administrtion
    Replies: 6
    Last Post: September 17th, 04:16 PM
  2. MySQL Access denied for user - Plesk / FC 2
    By rossn8tor@hotmail.com in forum Coldfusion Server Administration
    Replies: 1
    Last Post: November 9th, 04:31 PM
  3. Access denied problem, please help
    By Ryan A in forum PHP Development
    Replies: 1
    Last Post: August 23rd, 03:04 PM
  4. Replies: 0
    Last Post: August 23rd, 11:56 AM
  5. [PHP] Access denied problem, please help
    By Jim Lucas in forum PHP Development
    Replies: 1
    Last Post: August 23rd, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139