0

I tried:

GRANT ALL PRIVILEGES ON someuser_.* TO 'someuser'@'%';

but it allows me creating only one database someuser_ I want to allow user someuser for all the database-name starts with someuser_ [like cPanel]

I tired:

GRANT ALL PRIVILEGES ON someuser_*.* TO 'someuser'@'%';

but it returns me:

ERROR 1046 (3D000): No database selected
Amin
  • 681
  • 4
  • 9
  • 27
  • 1
    [GRANT with database name wildcard in MySQL?](https://stackoverflow.com/q/2668591/6248528) – Solarflare May 30 '18 at 15:35
  • Possible duplicate of [GRANT with database name wildcard in MySQL?](https://stackoverflow.com/questions/2668591/grant-with-database-name-wildcard-in-mysql) – Progman May 30 '18 at 18:03
  • Thanks, it worked for me. but the user cannot drop database now. – Amin May 31 '18 at 06:13

0 Answers0