Databases Reference
In-Depth Information
After clicking on Go , bill no longer exists in the mysql database. Also, all of his
privileges, including the privileges on the bill database, will have been transferred to
the new user— billy . However, the user definition of bill will still exist in memory,
and hence it's still effective. If we had chosen the delete the old one from the user
tables and reload the privileges afterwards option instead, the user definition of bill
would immediately have ceased to be valid.
Alternatively, we could have created another user based on bill , by making use
of the keep the old one choice. We can transfer the password to the new user by
choosing Do not change the password option, or change it by entering a new
password twice. The revoke all active privileges… option immediately terminates
the effective current privileges for this user, even if he or she is currently logged in.
 
Search WWH ::




Custom Search