How to grant access permision for multiple database and multiple tables to a user in MySQL?
GRANT ... ON dbname.tablename TO user@... IDENTIFIED BY ...;


You can grant ON *.*, ON dbname.*, ON db.tbl, or even on column(s).

You will need multiple GRANTs for multiple tables.