MySQL user access - table specific

2019-02-25 03:27发布

问题:

How do I give a user access to specific tables within a MySQL database?

回答1:

grant select on table to username


回答2:

Find the below example, Modify it according to your needs.
GRANT SELECT ON db_base.* TO db_user@'localhost' IDENTIFIED BY 'db_passwd';