Thanks for the advice. I had already gone through it. I have narrowed it down to the password. If I kill the password in mysql and connect from my pl script without a password I can connect no problem. How do I tell perl to use the same password encryption as mysql. I assume encryption is the problem here. | [reply] |
How are you setting your password in MySQL?
You have probably allready seen this, but...
If you change a password by using SET PASSWORD, INSERT, or UPDATE, you must encrypt the password using the PASSWORD() function. If you do not use PASSWORD() for these statements, the password will not work. For example, the following statement sets a password, but fails to encrypt it, so the user will not be able to connect afterward:
mysql> SET PASSWORD FOR 'abe'@'host_name' = 'eagle';
Instead, set the password like this:
mysql> SET PASSWORD FOR 'abe'@'host_name' = PASSWORD('eagle');
The PASSWORD() function is unnecessary when you specify a password using the GRANT statement or the mysqladmin password command, both of which automatically use PASSWORD() to encrypt the password.
| [reply] |
Even i had exactly the same issue with same code like you have. But i changed double codes to single code in the password field value and it worked!
| [reply] |