Access denied error in C# while connecting with MySql. I already have full access of Database

Question

Hi I am developing and application in which I need to connect to MySQL database on remote server using IP address.

I have used below connection string:

<connectionStrings>
<add name="con" connectionString="Server=***.***.***.***;Port=3306;Database=enview;Uid=myuser;Pwd=****" providerName="MySql.Data.MySqlClient"/>

When I try to open connection I am getting below error.

Authentication to host '***.***.***.***' for user 'myuser' using method 'mysql_native_password' failed with message: Access denied for user 'myuser'@'**my IP**' (using password: YES)

The server may not allow remote connections; assuming the credentials are in fact correct. — Mike Perrenoud
– Mike Perrenoud, Commented Nov 21, 2013 at 12:43
@Michael Perrenoud Server allowing remote connection. I tried with PHP it's working fine. — Ashok
– Ashok, Commented Nov 21, 2013 at 12:45

mikebutrimov · Accepted Answer · 2013-11-21 12:54:48Z

2

Maybe sql-server does not allow connections from non-server ip address, or you are prohibited to connect to database with non-server ip address. Check your permissions. May be your permissions were granted to username@localhost not to username@*

answered Nov 21, 2013 at 12:54

mikebutrimov

3651 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rishad2m8 · Accepted Answer · 2013-11-21 12:47:29Z

1

Your're not mentioned details about remote server. If you are using third party remote server containing MySQL database, please ensure that it support remote access. You can check it on MySQL workbench. Try to connect same database on MySQL workbench.

answered Nov 21, 2013 at 12:47

rishad2m8

1,51621 silver badges27 bronze badges

Collectives™ on Stack Overflow

Access denied error in C# while connecting with MySql. I already have full access of Database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related