User Accounts and Privileges - Learning MySQL and MariaDB - page 325

When you do this, all of the privileges related to lena_stankoska@lena_stankoska_home
will be changed for the new username and host. Let's check that by executing the follow-
ing:
SHOW GRANTS FOR 'lena'@'stankoskahouse.com';
+------------------------------------------------------------------------------+
| Grants for
[e-mail] |
+------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'lena'@'...' IDENTIFIED BY PASSWORD
'...' |
| GRANT SELECT ON `rookery`.* TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`eastern_birders_spottings` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`membership_prospects` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`survey_answers` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`surveys` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`survey_questions` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`eastern_birders` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`prospects` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`prize_winners` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`possible_duplicate_email` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`birdwatcher_prospects_import` TO
'lena'@'...'|
| GRANT SELECT (membership_type, human_id, name_last, formal_title,
name_first)|
| ON `birdwatchers`.`humans` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`bird_identification_tests` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`birdwatcher_prospects` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`bird_sightings` TO
'lena'@'...' |
| GRANT SELECT ON `birdwatchers`.`birding_events` TO
'lena'@'...' |