MySQL Server Administration with phpMyAdmin - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 252

User Name
The User name menu offers two choices. We can choose Use text field and input
a user name in the box, or we can choose Any user to create an anonymous user
(the blank user). Let's choose Use text field and enter bill .
Host
By default, this menu is set to Any host with % as the host value. The Local choice
means "localhost". The Use host table choice (which creates a blank value in the
host field) means to "look in the mysql.hosts table for database-specific privileges".
Choosing Use text field allows us to input the exact host value we want. Let's
choose Local .
Password
Even though it's possible to create a user without a password (with the No password
choice), it's best to have a password. We have to enter it twice (as we cannot see what
is entered) to confirm the intended password. Let's input bingo .
Some administrators prefer to improve security by having phpMyAdmin generate a
password itself. In the Generate Password dialog, a click on Generate puts a random
password (in clear) on-screen. At this point, we should note the password so that we
can pass it on to the user. Then a click on Copy puts this password in the Password
and Re-Type fields.
Global Privileges
Global privileges determine the user's access to all databases, so these privileges are
sometimes known as "superuser privileges". A normal user should not have any of
these privileges unless there is a good reason.
Of course, if we are really creating a superuser, we will select every global privilege
that he or she needs. These privileges are further divided into Data , Structure , and
Administration groups.
In our example, bill will not have any global privileges.
Resource Limits
We can limit the resources used by this user on this server (for example, the
maximum queries per hour). Zero means no limit. We will not impose any resources
limits on bill .