Devart Forums

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.

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:
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"

Thanks Pinturiccio. Works fine!