Mysql / Mariadb user grant to multiple database

Question

Would like to grant permission to a user on multiple databases in single command. I am getting syntax error when I try

grant all on abc.*, xyz.* TO 'user'@'10.10.0.10';

Please guide. Thanks.

Answer 1

You need to use multiple grant statements, one for each database:

grant all on abc.* TO 'user'@'10.10.0.10';
grant all on xyz.* TO 'user'@'10.10.0.10';