34,333
edits
Changes
no edit summary
</pre>
A database that is more established will likely contain more users, some of which will have been manually created, and others, as in the cvase case below, created as a result of installing a third-party which uses MySQL .
<pre>
== Creating a New MySQL User ==
In order to add a new user account it is necessary to use the ''CREATE USER'' statement. The creation of a new user account requires the user login name and an optional password. Regardless of the fact that the password is optional, it is unwise to add a new account without a password.
The syntax for creating a user account is as follows:
CREATE ''user name'' IDENTIFIED BY ''\'password\''';
== Deleting a MySQL User ==
