Issue of Connecting a remote Database of MYSQL in C#.net

Question

0.00/5 (No votes)

See more:

I Am Creating a Web Application to Attach a remote database of Mysql for which i have used a
Mysql Connector but When i am Running a application using given user id and password of database it Showing an error :"Access denied for user 'parkhya_parkhya'@'rws5.my-hosting-panel.com' (using password: YES) "

I tried a lot but still not finding any Solution to attache a database so Please Reply me Why
I am Facing this Problem. and What i do Solve this Problem in My Web Application.

Posted 28-Mar-13 3:18am

Lalit28

Add a Solution

Comments

[no name] 28-Mar-13 9:24am

There might be something wrong with your keyboard. It is randomly Placing Capitol letters where It does not Need To.
The error is pretty clear is it not? Either the user ID is incorrect or the password is incorrect or both that you are passing to that database. Pass the correct credentials to the database is your solution.

ZurdoDev 28-Mar-13 9:31am

The error tells you the issue.

[no name] 28-Mar-13 9:35am

Additionally if you are trying to connect to a remote database that is hosted by a provider, they may not allow you to directly connect to the database for security.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Khandekar · Answer 1 · 2013-03-28T08:43:00

Hello,

By default MySQL does not allow connections from remote machines. You will have to enable this. Open command prompt on the machine on which you have installed MySQL. The type in following command to grant the necessary privileges to the user.

GRANT ALL ON YOURDB.* TO 'parkhya_parkhya'@'rws5.my-hosting-panel.com' IDENTIFIED BY 'USER PASSWORD';

You can also GRANT specific privileges to the USER instead of ALL. Please have a look at MySQL Manual[^].

I am assuming that rws5.my-hosting-panel.com is the FQDN of the machine from where you are trying to establish the connection. You can even use IP Address, if name resolution is not working.

Regards,