Forums

mysql> SHOW GRANTS FOR 'scorpionero'@'%';
+-----------------------------------------------------------------------------------------+
| Grants for scorpionero@%                                                                |
+-----------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `scorpionero`@`%`                                                 |
| GRANT SELECT, DELETE, DROP, LOCK TABLES ON `scorpionero$default`.* TO `scorpionero`@`%` |
| GRANT SELECT, DELETE, DROP, LOCK TABLES ON `scorpionero$tokens`.* TO `scorpionero`@`%`  |
| GRANT SELECT, DELETE, DROP, LOCK TABLES ON `scorpionero$webapp`.* TO `scorpionero`@`%`  |
+-----------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `scorpionero$webapp`.* TO 'scorpionero'@'%';
ERROR 1044 (42000): Access denied for user 'scorpionero'@'%' to database 'scorpionero$webapp'
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `scorpionero$tokens`.* TO 'scorpionero'@'%';
ERROR 1044 (42000): Access denied for user 'scorpionero'@'%' to database 'scorpionero$tokens'
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `scorpionero$default`.* TO 'scorpionero'@'%';
ERROR 1044 (42000): Access denied for user 'scorpionero'@'%' to database 'scorpionero$default'
mysql>