Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.09 KB | None | 0 0
  1. mysql> SHOW GRANTS FOR 'root'@'localhost';
  2. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  3. | Grants for root@localhost |
  4. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  5. | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
  6. +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> GRANT ALL ON *.* TO 'root'@'localhost';
  10. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
  11. mysql>
  12.  
  13. mysql> select Grant_priv, Super_priv from user where User='root';
  14. +------------+------------+
  15. | Grant_priv | Super_priv |
  16. +------------+------------+
  17. | Y | Y |
  18. +------------+------------+
  19. 1 row in set (0.00 sec)
  20.  
  21. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement