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'@'10.10.0.10';
grant all on xyz.* TO 'user'@'10.10.0.10';

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top