SHOW:
|
|
- or go back to the newest paste.
| 1 | CREATE USER 'USR'@'%' IDENTIFIED BY 'x'; | |
| 2 | - | CREATE USER 'USR' IDENTIFIED BY 'x'; |
| 2 | + | |
| 3 | GRANT ALL ON *.* TO 'USR'@'%'; | |
| 4 | - | GRANT ALL ON *.* TO 'USR'; |
| 4 | + | |
| 5 | REVOKE UPDATE ON paymentmethods.* FROM 'USR'@'%'; /* 0 17:39:09 REVOKE UPDATE ON paymentmethods.* FROM 'USR'@'%' Error Code: 1141. There is no such grant defined for user 'USR' on host '%' */ | |
| 6 | - | REVOKE UPDATE ON paymentmethods.* FROM 'USR'; /* Error: 0 17:12:10 REVOKE UPDATE ON paymentmethods.* FROM 'HOW' Error Code: 1141. There is no such grant defined for user 'HOW' on host '%' */ |
| 6 | + | GRANT UPDATE ON paymentmethods.active TO 'USR'@'%'; |
| 7 | - | GRANT UPDATE ON paymentmethods.active TO 'USR'; |
| 7 | + | |
| 8 | /* | |
| 9 | btw: | |
| 10 | SHOW GRANTS FOR 'USR'@'%' | |
| 11 | result: | |
| 12 | 'GRANT ALL PRIVILEGES ON *.* TO ''USR''@''%'' IDENTIFIED BY PASSWORD ''*x''' | |
| 13 | */ |
