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