I cannot find how to go about creating a MySQL user that would have read-only access to the MySQL database. I want to give our reporting analyst a direct connection to the database. He does not need write permissions to pull his reports and I would prefer to create a separate user in order to make sure nothing bad happens.
I do not think the MySQL user found under the database tab on https://cloud.acquia.com has sufficient access to create MySQL users, right? MySQL workbench won't let me into User/Privileges management.