Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access denied for user (GoDaddy MySql)

Posted on 2009-07-06
3
Medium Priority
?
850 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"/>

0
Comment
Question by:RobertNZana
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 2000 total points
ID: 24787133
Wrong username or password, or the MySQL server has no user that matches that host. Verify with GoDaddy that you have the right password.
0
 
LVL 9

Author Comment

by:RobertNZana
ID: 24787312
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.
0
 
LVL 9

Author Closing Comment

by:RobertNZana
ID: 31600233
See my comment as well as this provides the final solution.  Thanks!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question