Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> create database test1;
- Query OK, 1 row affected (0.00 sec)
- mysql> grant usage on *.* to 'test'@'%' identified by 'test';
- ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
- mysql> show grants for root;
- +--------------------------------------------------------------------------------------------------------------+
- | Grants for root@% |
- +--------------------------------------------------------------------------------------------------------------+
- | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*hash_is_here' |
- +--------------------------------------------------------------------------------------------------------------+
- 1 row in set (0.00 sec)
- mysql> select user();
- +-----------------+
- | user() |
- +-----------------+
- | root@172.17.0.4 |
- +-----------------+
- 1 row in set (0.01 sec)
- GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*some_hash' WITH GRANT OPTION
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement