Home / server / Questions / 191649
Accepted
Detritus Maximus
Asked: 2010-10-17 07:23:14 +0800 CST

MYSQL remote read only access, how do I set it up?

  • 772

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.

mysql permissions

1 Answers

  1. Best Answer
    mysql>grant select on *.* to 'dude'@'boingoboingo.local';

    or only one database

    mysql>grant select on DATABASE_NAME.* to 'dude'@'boingoboingo.local';
    • 7