Re: How to call MySQL's PASSWORD() from Class::DBI?

Side note. If you are changing a MySQL database password, then be aware that MySQL has the much simpler syntax SET PASSWORD=PASSWORD('mypassword'), which allows non-anonymous users to change their password.

What you are doing with the "user" table looks suspiciously complex, unnecessary, and possibly insecure. Look at the manual.

Comment on Re: How to call MySQL's PASSWORD() from Class::DBI? Download Code

Replies are listed 'Best First'.
Re: Re: How to call MySQL's PASSWORD() from Class::DBI? by monsieur_champs (Curate) on Dec 24, 2003 at 13:29 UTC
Not exactly. I'm trying to change a PASSWORD() encripted value inside a table that belongs to my system, not to MySQL. Thank you for the insight and tip. Indeed, I've decided to use the triggers approach suggested above, but can't figure out what I'm doing wrong with the triggers, yet. "In few words, translating PerlMonks documentation and best articles to other languages is like building a bridge to join other Perl communities into PerlMonks family. This makes the family bigger, the knowledge greather, the parties better and the life easier." -- monsieur_champs	[reply]

Replies are listed 'Best First'.

Re: Re: How to call MySQL's PASSWORD() from Class::DBI?
by monsieur_champs (Curate) on Dec 24, 2003 at 13:29 UTC

Not exactly. I'm trying to change a PASSWORD() encripted value inside a table that belongs to my system, not to MySQL. Thank you for the insight and tip. Indeed, I've decided to use the triggers approach suggested above, but can't figure out what I'm doing wrong with the triggers, yet.

"In few words, translating PerlMonks documentation and best articles to other languages is like building a bridge to join other Perl communities into PerlMonks family. This makes the family bigger, the knowledge greather, the parties better and the life easier." -- monsieur_champs

[reply]