drop user twg@'%';

create user twg@'%' identified by 'test';

grant create, drop on `wildcard_grants%`.* to twg@'%';

grant all privileges on `wildcard_grants`.* to twg@'%';

drop database if exists wildcard_grants;

create database wildcard_grants;

use wildcard_grants;

create table t(id int);

mysql -utwg -ptest -hlocalhost wildcard_grants;

MariaDB [wildcard_grants]> insert into t values(1);

ERROR 1142 (42000): INSERT command denied to user 'twg'@'localhost' for table 't'

drop user twg@'%';

create user twg@'%' identified by 'test';

grant all privileges on `wildcard_grants`.* to twg@'%';

grant create, drop on `wildcard_grants%`.* to twg@'%';

drop database if exists wildcard_grants;

create database wildcard_grants;

use wildcard_grants;

create table t(id int);

mysql -utwg -ptest -hlocalhost wildcard_grants;

MariaDB [wildcard_grants]> insert into t values(1);

Query OK, 1 row affected (0.00 sec)