c# - Authentication failed using method mysql_native_password -


trying connect mysql on web host, using connector/net c#/winforms in visual studio 2012 update 3, getting below error message:

authentication host '1.1.1.1' user 'username@mydomain.com' using method 'mysql_native_password' failed message: access denied user 'username@mydomain.com'@'2.2.2.2' (using password: yes)

string connectionstring = "server=1.1.1.1;port=3306;database=databasename;uid=username@mydomain.com;password=mypassword;";  mysqlconnection connection = new mysqlconnection(connectionstring); connection.open(); 

i connecting remotely, have whitelisted ip (and temporary whitelisted (%) test), triple checked username , password , ip.

i tried username without domain ( username rather username@mydomain.com) gave me below error:

authentication old password no longer supported, use 4.1 style passwords.

any assistance appreciated, thanks!

its problem of 'remote database access hosts'. "you can allow external web servers access mysql databases adding domain name list of hosts able access databases on web site."

mysql access not granted ip address of system @ application running.(in case '2.2.2.2' ).

note:- '2.2.2.2' public ip address.


Comments