[DIGITALOCEAN] mysql database cluster - fourslickz/notes GitHub Wiki

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

MySQL [(none)]> SHOW GRANTS FOR 'sulis';
+-----------------------------------+
| Grants for sulis@%                |
+-----------------------------------+
| GRANT USAGE ON *.* TO "sulis"@"%" |
+-----------------------------------+
1 row in set (0.001 sec)

MySQL [(none)]> GRANT SELECT,INSERT,UPDATE,DELETE ON stg_produksi.* TO 'sulis'@'%';
Query OK, 0 rows affected (0.002 sec)

MySQL [(none)]> GRANT SELECT,INSERT,UPDATE,DELETE ON stg_integrasi.* TO 'sulis'@'%';
Query OK, 0 rows affected (0.002 sec)

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

MySQL [(none)]>