creating a read-only user in phpMyAdmin
mysql, php, phpmyadmin
Solution
If the user should only be able to read the database, they should not be granted any of the permissions listed under "Structure" or "Administration".
Problem
I'm trying to create a user that can only read from a database. This is the user creation screen on phpMyAdmin. For the first set (`Data`), I figured I only need `SELECT`. But I'm not sure about the second and third sets (`Structure` and `Administration`). Some options like `Event` `Trigger` `Execute` are a bit confusing. Do I need those for a read-only user? What exactly do I need to enable/disable?