Open main menu

Changes

MySQL Users and Security

247 bytes added, 13:58, 29 October 2007
→‎Renaming a MySQL User
== Renaming a MySQL User ==
 
The account name of a MySQL user can be changed using the ''RENAME USER'' statement, the syntax of which is:
 
RENAME USER ''user name'' TO ''new user name'';
 
For example:
 
<pre>
RENAME USER 'johnB'@'localhost' TO 'johnBrown'@'localhost';
</pre>
== Changing the Password for a MySQL User ==