User to change his MySQL password

[paulsim]

Hi All

Any ideas on how I can get a user to change his own MySQL password-----

---- do I have to give them access to mysql.users?????

I would like a nice safe way of doing this.

Paul

[radley]

make a php page and a select statement where the user id or whatever equals the user in the database, for instance

SELECT * FROM user WHERE User = 'Joe'

and then an update

UPDATE user SET Password = 'newpass' WHERE User = 'Joe'