With this
in place, user bill could create the databases bill_test, bill_2, bill_payroll
and so on; phpMyAdmin does not pre-create the databases in this case.
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.
The following screenshot shows the status of the screen just before hitting Go to
create this user's definition (with the other fields left set to their default values):
MySQL Server Administration
[ 286 ]
Editing a User
The page used to edit a user appears after a user's creation, or whenever we click
Edit for a user in the User overview page. There are four sections on this page,
each with its own Go button, so each section is operated independently and has a
distinct purpose.
Edit Privileges
The section for editing the user's privileges has the same look as the Add a new User
dialog, and is used to view and to change global privileges.
Pages:
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261