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'@'%';

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.