Solved

Access denied for user (GoDaddy MySql)

Posted on 2009-07-06
3
822 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 500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 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