We help IT Professionals succeed at work.

Access denied for user (GoDaddy MySql)

RobertNZana
RobertNZana asked
on
Medium Priority
957 Views
Last Modified: 2012-06-27
ASP.NET app trying to access data in a MySql db hosted on GoDaddy.  When running the query I get this message...

"Access denied for user 'myapp'@'xx.xxx.217.88' (using password: YES)"

Any idea why?  Here's the connection string in the web.config...
        <remove name="connectstring" />
        <add name="connectstring" connectionString="User Id=myapp;Password=mypwd;Host=myapp.db.2416160.hostedresource.com;Persist Security Info=True;Connection Timeout=120;Default Command Timeout=120;" providerName="Devart.Data.MySql"/>

Comment
Watch Question

Top Expert 2005
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
You're right.  It was the wrong host.  It's misleading because they keep showing you a "host" on the screen, but when I connected with MySql it showed me the "Host" and "Network Name".  It was the NETWORK NAME that I had to use in my web.config connection string.  I hope this helps people in the future.

Author

Commented:
See my comment as well as this provides the final solution.  Thanks!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.