Connecting to MySQL

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:

If silota is the read-only username:

GRANT SELECT ON my_database.schema_name TO 'silota'@'%';