How to Create a Read-Only MySQL User
Simple enough problem, but I couldn’t find a quick solution that worked out of the box for my configuration. Here’s a quick guide to setting up a read-only user on your MySQL server (useful for safely inspecting production databases): Note that you may need to change Host = ‘localhost’ depending on your MySQL server configuration.
Continue Reading