Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. mysql> create database test1;
  2. Query OK, 1 row affected (0.00 sec)
  3.  
  4. mysql> grant usage on *.* to 'test'@'%' identified by 'test';
  5. ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
  6. mysql> show grants for root;
  7. +--------------------------------------------------------------------------------------------------------------+
  8. | Grants for root@% |
  9. +--------------------------------------------------------------------------------------------------------------+
  10. | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*hash_is_here' |
  11. +--------------------------------------------------------------------------------------------------------------+
  12. 1 row in set (0.00 sec)
  13. mysql> select user();
  14. +-----------------+
  15. | user() |
  16. +-----------------+
  17. | root@172.17.0.4 |
  18. +-----------------+
  19. 1 row in set (0.01 sec)
  20.  
  21. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*some_hash' WITH GRANT OPTION
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement