>Thanks. So how does one use the password function in MySQL 5?
Most probably just the same, but your MySQL 4 password hashes are
incompatible
with MySQL 5 password hashes.
A search on "password" in the MySQL docs returns quite some stuff, see:
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
http://dev.mysql.com/doc/mysql/search.php?version=5.0&q=password&from=%2Fdoc%2Frefman%2F5.0%2Fen%2F&lang=en
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com