Posible bug in dotConnect for MySQL

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
marioloko
Posts: 2
Joined: Tue 21 Aug 2012 21:47

Posible bug in dotConnect for MySQL

Post by marioloko » Tue 21 Aug 2012 21:57

Hi friends, I've a strange problem connecting Http Tunneling

I've this credentials

cnn.UserId = "bbdd_noa"
cnn.Password = "NI{{f0sOyt\\k&I8w_c"
cnn.open()

NOT CONNECT --> error Access for user 'bbdd_noa'@'127.0.0.1' is denied (user password: YES)

Now, i change password for user "bbdd_noa" in PLESK and...

cnn.UserId = "bbdd_noa"
cnn.Pssword = "T0d0p3rr4$"
cnn.open()

CONNECT SUCCESSFULLY

Why? all parameters is ideantical, except PASSWORD, with the complex password NOT CONNECT, is a component bug?

Thanks in advance.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Posible bug in dotConnect for MySQL

Post by Pinturiccio » Wed 22 Aug 2012 12:11

MySQL uses backslash as an escape character, and interpretes double backslash as a singular backslash. After you have set the "NI{{f0sOyt\\k&I8w_c" password to your "bbdd_noa" user, MySQL interpretes this password as "NI{{f0sOyt\k&I8w_c". Use the following code to establish a connection:

Code: Select all

cnn.UserId = "bbdd_noa"
cnn.Password = "NI{{f0sOyt\k&I8w_c"
cnn.Open()
If you want your user to have exactly the "NI{{f0sOyt\\k&I8w_c" password, you should use the following string to specify the password: "NI{{f0sOyt\\\\k&I8w_c"

marioloko
Posts: 2
Joined: Tue 21 Aug 2012 21:47

Re: Posible bug in dotConnect for MySQL

Post by marioloko » Thu 23 Aug 2012 07:40

Thanks Pinturiccio. Works fine!

Post Reply