??? ??? ??? ??? ??? ??? ??? ??? ??? ???
MySQL Server Administration
[ 282 ]
User and Privileges Management
The Privileges sub-page in the Server view contains dialogs to manage MySQL
user accounts, and their privileges on global, database, and table levels. This
sub-page is centered on the user and is hierarchical: for example, when editing a
user's privileges, we can see the global privileges as well as the database-specific
privileges. Then, we can go deeper to see the table-specific privileges for this
database-user combination.
The User Overview
The first page displayed when we enter the Privileges sub-page is called User
overview. This shows all user accounts and a summary of their global privileges:
From this page, we can:
Edit a user's privileges with the Edit link on a user's line.
Use the checkboxes to remove users with the Remove selected users dialog.
Access the page where the Add a new user dialog is available.
Reload the privileges. The effective privileges (the ones against which the
server bases its access decisions) are the privileges that are located in the
server's memory.
??? ??? ??? ???
Chapter 19
[ 283 ]
Modifications to the privileges made from the User Overview page are made
both in memory and on disk, in the mysql database. Modifications made
directly on the mysql database do not have immediate effect.
Pages:
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258