MySQL :: MySQL 5.0 Reference Manual :: 13.7.1.6 SET PASSWORD Syntax

With no FOR user clause, this statement sets the password for the current user: SET PASSWORD = PASSWORD('cleartext password'); Any client who connects to the server using a nonanonymous account can change the password ...

dev.mysql.com