1. ### AS root user
  3. mysql> SHOW GRANTS FOR 'nova'@'test1';
  4. +---------------------------------------------------------------------------------------------------------+
  5. | Grants for nova@test1 |
  6. +---------------------------------------------------------------------------------------------------------+
  7. | GRANT USAGE ON *.* TO 'nova'@'test1' IDENTIFIED BY PASSWORD '*6D539E9B................................' |
  8. | GRANT ALL PRIVILEGES ON `nova`.* TO 'nova'@'test1' |
  9. +---------------------------------------------------------------------------------------------------------+
  10. 2 rows in set (0.00 sec)
  12. mysql> SHOW GRANTS FOR 'nova'@'localhost';
  13. +-------------------------------------------------------------------------------------------------------------+
  14. | Grants for nova@localhost |
  15. +-------------------------------------------------------------------------------------------------------------+
  16. | GRANT USAGE ON *.* TO 'nova'@'localhost' IDENTIFIED BY PASSWORD '*6D539E9B................................' |
  17. | GRANT ALL PRIVILEGES ON `nova`.* TO 'nova'@'localhost' |
  18. +-------------------------------------------------------------------------------------------------------------+
  19. 2 rows in set (0.00 sec)
  21. mysql> SHOW GRANTS FOR 'nova'@'%';
  22. +-----------------------------------------------------------------------------------------------------+
  23. | Grants for nova@% |
  24. +-----------------------------------------------------------------------------------------------------+
  25. | GRANT USAGE ON *.* TO 'nova'@'%' IDENTIFIED BY PASSWORD '*6D539E9B................................' |
  26. | GRANT ALL PRIVILEGES ON `nova`.* TO 'nova'@'%' |
  27. +-----------------------------------------------------------------------------------------------------+
  28. 2 rows in set (0.00 sec)
  30. mysql> SHOW GRANTS FOR 'nova'@'10.21.0.0/255.255.0.0';
  31. +-------------------------------------------------------------------------------------------------------------------------+
  32. | Grants for [email protected]/255.255.0.0 |
  33. +-------------------------------------------------------------------------------------------------------------------------+
  34. | GRANT USAGE ON *.* TO 'nova'@'10.21.0.0/255.255.0.0' IDENTIFIED BY PASSWORD '**6D539E9B................................' |
  35. | GRANT ALL PRIVILEGES ON `nova`.* TO 'nova'@'10.21.0.0/255.255.0.0' |
  36. +-------------------------------------------------------------------------------------------------------------------------+
  37. 2 rows in set (0.00 sec)