Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM some_other_database_on_the_same_server_as_the_currently_used_database.some_table WHERE id = 1
- mysql> SHOW GRANTS FOR ana_index@localhost;
- | GRANT USAGE ON *.* TO 'ana_index'@'localhost' IDENTIFIED BY PASSWORD '*...'
- | GRANT ALL PRIVILEGES ON `test`.* TO 'ana_index'@'localhost'
- mysql> SELECT * FROM mysql.user WHERE user = 'ana_index'G
- *************************** 1. row ***************************
- Host: localhost
- User: ana_index
- Password: *1E62D0DB2482ED4455102B56D823285C02BAAF8F
- Select_priv: N
- Insert_priv: N
- Update_priv: N
- Delete_priv: N
- Create_priv: N
- (etc)
- mysql> SELECT * FROM mysql.db WHERE user = 'ana_index'G
- *************************** 1. row ***************************
- Host: localhost
- Db: test
- User: ana_index
- Select_priv: Y
- Insert_priv: Y
- Update_priv: Y
- Delete_priv: Y
- Create_priv: Y
- Drop_priv: Y
- Grant_priv: N
- (etc)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement