Securing the Database - Database Design Manual: Using MySQL for Windows - page 136

Figure 12.4 Logging in to the monitor with our new user.

come into effect when a user logs in. As Mary was logged in when we changed her privi-
leges, she still can access everything. To log out, at the command prompt type:

exit

and then type:

mysql —user=Mary —password=yeti

to log in again. Now change to the mysql database and select everything from the user
table again as follows:

use mysql;
SELECT * from user;