[opensuse] MySQL encryption agent

Greetings list openSuSe 10.2 MySQL 5.0.26 How can I establish what the standard encryption agent(s) is (are) for MySQL? SELECT ENCRYPT('password'), PASSWORD('password'), MD5('password'); generates a different encrypted password to what: select * from user; does, and I think this is why my database lookups aren't auth'ing. How would I go about changing the standard encryption agent if I could? Regards, Stuart -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org