Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- >mysql -uusername -ppassword -hhost.domain.com
- >USE mydb
- >select 1g
- >select * from mytable
- >SHOW GRANTS FOR 'username'@'host.domain.com'
- | Grants for user@host.domain.com |
- +-----------------------------------------------------------------------------------+
- | GRANT USAGE ON *.* TO 'user'@'host.domain.com' IDENTIFIED BY PASSWORD <secret> |
- | GRANT SELECT ON `different_owner`.`mytable` TO 'username'@'host.domain.com' |
- +-----------------------------------------------------------------------------------+
- >select * from different_owner.mytable
Add Comment
Please, Sign In to add comment