Open main menu

Changes

MySQL Users and Security

451 bytes added, 14:03, 29 October 2007
→‎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>