MySQL Configuration
2 min
Purpose
In MySQL, the objective is to grant [username] read access to specific schemas without modification rights. This MySQL account is solely needed for connecting and retrieving data securely.
Grant Permissions
GRANT SELECT ON performance_schema .* TO ’[ username ]’@’%’;Schema can differ; performance_schema is an example. The only need is for this MySQL account to connect.