Connecting to MySQL
Please review the introductory connecting your database document on security practices, IP whitelists, etc.
MySQL identifies connections by the username and the IP address of the connection. You can use the
% character to act as a wildcard for the IP address:
silota is the read-only username:
grant select on my_database.schema_name to 'silota'@'%';
If there's a specific table in your schema that holds private information and you don't want the
silota user to query, you can revoke the permission to
select from it:
revoke select on table_name FROM 'silota'@*
No spam, ever! Unsubscribe any time. Learn more about the product.