Skip to main content

Timeline for Wildcard in CREATE grant in MySQL

Current License: CC BY-SA 3.0

10 events
when toggle format what by license comment
Feb 13, 2020 at 8:47 comment added Yvan @fraff I would try to set large privileges (full table, all columns), and reduce the privileges one by one to find it out. I don't use such privileges, so I won't help much in the end. Don't forget to use flush privileges after each change!
Feb 11, 2020 at 14:44 comment added fraff grant is created, I can see it with show grants for .. but user still can't create or frop table matching wildcard. I'm using mysql 5.7
Feb 11, 2020 at 14:04 comment added Yvan @fraff it should be like this: GRANT CREATE ON `foo`.`bar%` TO .... To add a backtick you should prefix it by an antislash: `\``
Feb 10, 2020 at 13:30 comment added fraff I tried, with backticks (I don't know how to add backticks in stackexchange comments without ruining indentation) on mysql5.7 but it didn't work. If you manage to do it please let me know, I'm still interested.
Feb 10, 2020 at 12:23 comment added Yvan @fraff it should. But you've used single quotes ' instead of backtick `. You can even go down to column privileges (see dev.mysql.com/doc/refman/8.0/en/…)
Feb 10, 2020 at 9:48 comment added fraff Note it does not work at table level, GRANT CREATE ON 'foo'.'bar%' TO .. won't work
S Jun 13, 2016 at 15:58 history suggested dr_ CC BY-SA 3.0
Corrected wrong syntax; done other trivial changes because the edit must be 6 characters or more.
Jun 13, 2016 at 15:47 vote accept dr_
Jun 13, 2016 at 15:47 review Suggested edits
S Jun 13, 2016 at 15:58
Jun 7, 2016 at 7:03 history answered Yvan CC BY-SA 3.0