34,333
edits
Changes
→Changing the Password for a MySQL User
== Changing the Password for a MySQL User ==
The password assigned to a user account can be changed using the SET PASSWORD statement. TO change the password for your own account, use the following syntax:
SET PASSWORD = Password('newpassword');
To alter the password for another user, simply include the user account name in a SET PASSWORD FOR statement. For example, to change the password of our example account:
<pre>
SET PASSWORD FOR 'johnB'@'localhost' = Password('newpassword');
</pre>
