Database Reference
In-Depth Information
This assigns privileges only for the chosen database. We can also choose
Use text
ield
and enter a database name. We could insert a non-existent database name, so
that this user can create it later (provided we give him/her the
CREATE
privilege in
the next panel). We can also use special characters, such as the underscore and the
percent sign for wildcards.
For example, entering
bill
here would enable him to create a
bill
database, and
entering
bill%
would enable him to create a database with any name that starts
with
bill
. For our example, we will enter
bill
.
The next screen is used to set
bill
is privileges on the
bill
database and create
table-specific privileges.
To learn more about the meaning of a specific privilege, we can move the mouse
over a privilege name (which is always in English), and an explanation about this
privilege appears in the current language. We give
SELECT
,
INSERT
,
UPDATE
,
DELETE
,
CREATE
,
ALTER
,
INDEX
, and
DROP
privileges to
bill
on this database.
We then click
Go
.
Search WWH ::
Custom Search