Trying to grant a user `select` privilege on multiple tables using wildcards as following:

```
GRANT SELECT ON 'DBname'.'foo_%' TO 'username'@'%' IDENTIFIED BY 'password';

```

But keep giving the following error:

```
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''DBname'.'foo_%' TO 'username'@'%' IDENTIFIED BY 'password'' at line 1

```

Server version: 5.7.30-log MySQL Community Server (GPL)

I'm sure that the syntax of the query is correct, but for some reason it won't accept it, Any advise?