Database Reference
In-Depth Information
After the privileges have been assigned, the interface stays at the same place, so that
we can refine these privileges further. We cannot assign table-specific privileges for
the moment, as the database yet does not exist.
The way to go back to bill is 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 either to change bill's
password or to remove it. Removing the password will enable bill to login without
a password.
Changing login information or copying a user
This dialog can be used to change the user's login information, or to copy his/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 .
 
Search WWH ::




Custom Search