5.5.2. Adding User Accounts
GRANTare described in Section 12.4.1, “Account Management Statements”.
phpMyAdminis one such program.
rootuser, and the
rootaccount must have the
INSERTprivilege for the
mysqldatabase and the
NO_AUTO_CREATE_USERwill prevent the server from accepting some of the statements. Workarounds are indicated for these cases. For more information about SQL modes and their effect on grant table manipulation, see Section 5.1.7, “Server SQL Modes”, and Section 220.127.116.11, “
mysql --user=root mysql
rootaccount, you will also need to supply a
-poption, both for this mysql command and for those later in this section.
root, you can add new accounts.