[DIGITALOCEAN] revoke users grant access - fourslickz/notes GitHub Wiki

MySQL [(none)]> REVOKE ALL ON *.* FROM 'user_name'@'%';
Query OK, 0 rows affected (0.004 sec)

MySQL [(none)]> GRANT SELECT ON database_name.* TO 'user_name'@'%';
Query OK, 0 rows affected (0.011 sec)

MySQL [(none)]> flush privileges;
Query OK, 0 rows affected (0.003 sec)

MySQL [(none)]>