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:

If 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'@*

Next Generation SQL Data Analysis Write SQL, visualize data, and share your results. Onboarding forward-thinking teams now:

No spam, ever! Unsubscribe any time. Learn more about the product.