MySQL Server Administration
[ 288 ]
After the privileges have been assigned, the interface stays at the same place so that
we can further refine these privileges. We cannot assign table-specific privileges for
the moment because the database does not yet exist.
The way to go back to bill's general privileges page is to click the
'bill'@'localhost' title:
This brings us back to the familiar page, except for a change in one section:
We see the existing privileges on the bill database for user bill (which we can Edit or
Revoke), and we can add privileges for bill on another database. We also see that
bill has no table-specific privilege on the bill database.
Changing the Password
This dialog is part of the Edit user page, and we can use it to change bill's password
or to remove it??”enabling bill to login without a password:
Chapter 19
[ 289 ]
Changing Login Information or Copying a User
This dialog can be used to change the user's login information, or to copy his or her
login information to a new user:
For example, suppose that Bill calls and tells us that he prefers the login name billy
instead of bill. We just have to add a y to the user name, choose Local as the host,
and select delete the old one from the user tables:
MySQL Server Administration
[ 290 ]
After this operation, bill no longer exists in the mysql database, and all his
privileges, including the privileges on the bill database, will have been transferred
to the new user, billy.
Pages:
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263