Timeline for MySQL Mistake with GRANT OPTION
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 20, 2013 at 12:27 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
edited tags; edited title
|
| Oct 20, 2013 at 10:03 | history | migrated | from serverfault.com (revisions) | ||
| Oct 20, 2013 at 9:14 | answer | added | Mats Kindahl | timeline score: 3 | |
| Oct 20, 2013 at 9:09 | comment | added | John Tate | I have been doing this for as long as I've been making backups. What about REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1, user2, user3; Does that work? | |
| Oct 20, 2013 at 9:06 | comment | added | MadHatter | Restore your mysql database from backups. Or delete all the users, and create new ones with different names: the permissions will still be in the grant tables, but noone will be able to avail themselves of them as no user will match. | |
| Oct 20, 2013 at 8:41 | history | asked | John Tate | CC BY-SA 3.0 |