MySQL: Set user password

SET PASSWORD FOR 'bob'@'%.example.org' = PASSWORD('cleartext password');