Apply the select privilege to all users in mysql
Try this:

mysql&gt; select user,host from mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| debian-sys-maint | localhost |
| eroom            | localhost |
| musr             | localhost |
| musr             | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)

mysql&gt; select concat('GRANT SELECT ON *.* to "',user,'"@"',host,'";') into outfile '/tmp/select_script.sql' FROM mysql.user;
Query OK, 4 rows affected (0.00 sec)

mysql&gt; source /tmp/select_script.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)