I know you can set permissions for MySQL users in the panel, but they seem to be only global (i.e., to all tables). How do I set permissions by table? For example, I’d like to grant access for a certain user only to one table, something like:
GRANT SELECT ON database.table TO ‘user’@‘localhost’ IDENTIFIED BY ‘password’;
Thanks a lot.