Re: Help with programming for MySQL encrypted passwords?

[Mark Matthews]

None of the clients pass the password in clear text.

If you're writing an application, you _shouldn't_ be using the passwords that are used for the database (in fact the documentation actually discourages this!) for your application's authentication and authorization mechanisms.

Use your own password scheme, hopefully using the SHA1 or MD5 functionality built into MySQL. Do _not_ use the PASSWORD() function, as that's really supposed to be used only for MySQL grant tables, and is subject to change functionality at any time.