Guest User

Untitled

a guest
Apr 20th, 2018
216
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. >mysql -uusername -ppassword -hhost.domain.com
  2. >USE mydb
  3. >select 1g
  4.  
  5. >select * from mytable
  6.  
  7. >SHOW GRANTS FOR 'username'@'host.domain.com'
  8.  
  9. | Grants for user@host.domain.com |
  10. +-----------------------------------------------------------------------------------+
  11. | GRANT USAGE ON *.* TO 'user'@'host.domain.com' IDENTIFIED BY PASSWORD <secret> |
  12. | GRANT SELECT ON `different_owner`.`mytable` TO 'username'@'host.domain.com' |
  13. +-----------------------------------------------------------------------------------+
  14.  
  15. >select * from different_owner.mytable
Add Comment
Please, Sign In to add comment