users for mysql mariadb can access multiple databases

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

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

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top