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.
Posible bug in dotConnect for MySQL
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Posible bug in dotConnect for MySQL
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"
Code: Select all
cnn.UserId = "bbdd_noa"
cnn.Password = "NI{{f0sOyt\k&I8w_c"
cnn.Open()
Re: Posible bug in dotConnect for MySQL
Thanks Pinturiccio. Works fine!