Changes

MySQL Users and Security

197 bytes added, 20:35, 28 October 2007
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 ==