34,333
edits
Changes
→Creating a New MySQL User
The syntax for creating a user account is as follows:
CREATE ''user name'' IDENTIFIED BY ''\'password\''';
For example, to create a new account for a user called johnB which is protected by a password we can issue the following statement:
<pre>
CREATE USER 'johnB'@'localhost' IDENTIFIED BY 'yrthujoi';
</pre>
== Deleting a MySQL User ==
