CODEWITHSUNDEEP
mysql
Mawg
Mawg

Reputation: 40140

Can I grant access to databases with prefix then wild card?

Can I GRANT ALL PRIVILEGES ON a*.* TO 'my_user'@'%' WITH GRANT OPTION; ?

I just want the user to only have access to all databases beginning with "my_prefix_" but not, for instance, to "mysql".

Upvotes: 45

Views: 25614

Answers (1)

Rudie
Rudie

Reputation: 53821

Yes, you can.

This is what phpMyAdmin does when I make a user jaap and use the option Grant all privileges on wildcard name (username\_%):

GRANT ALL PRIVILEGES ON  `jaap\_%` . * TO  'jaap'@'localhost';

That's what you mean, right?

PS
As you can see, the _ is escaped, because in (My)SQL an unescaped _ means 'one character'. (Like . in regex.) In this case, you want the _ to be literal, so databases must start with jaap_

Upvotes: 92

Related Questions