I've seen stuff on how to enable remote access, but never how to restrict it so that users cannot make any changes. I tried doing this:
mysql> create user 'dude'@'boingoboingo.local' IDENTIFIED BY '007'; Query OK, 0 rows affected (0.00 sec)
This user cannot access any databases remotely. What do I need to grant for read only.