Databases Reference
In-Depth Information
The second part of the
Add a new User
dialog is where we will specify the user's
global privileges, which apply to the server as a whole (see the
Assigning global
privileges
section of this chapter), as shown in the following screenshot:
Entering the username
The
User name
menu offers two choices. We can choose
Use text field:
and enter a
username in the box, or we can choose
Any user
to create an anonymous user (the
blank user). More details about the anonymous user are availab
le at
http://dev.
mysql.com/doc/refman/5.5/en/connection-access
.html
. Let us choose
Use text
field:
and enter
bill
.
Assigning a host value
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.host
table for database-specific privileges.
Choosing
Use text field:
allows us to enter the exact host value we want. Let us
choose
Local
.
Search WWH ::
Custom Search