Forums

mysql> USE radagast$bandTogether;
Database changed
mysql> SOURCE bandtogether.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)
ERROR 1044 (42000): Access denied for user 'radagast'@'%' to database 'bandTogether'
ERROR 1044 (42000): Access denied for user 'radagast'@'%' to database 'bandTogether'
ERROR 1142 (42000): CREATE command denied to user 'radagast'@'10.0.0.117' for table 'users'
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
  CONSTRAINT `fk_bands_users1`
    FOREIGN KEY (`founder`)
    REFERENC' at line 10
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
  INDEX `fk_users_has_bands_users_idx` (`user_id` ASC) VISIBLE,
  CONST' at line 5
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> show grants;
+---------------------------------------------------------------------+
| Grants for radagast@%                                               |
+---------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'radagast'@'%'                                |
| GRANT ALL PRIVILEGES ON `radagast$bandTogether`.* TO 'radagast'@'%' |
| GRANT ALL PRIVILEGES ON `radagast$default`.* TO 'radagast'@'%'      |
| GRANT ALL PRIVILEGES ON `radagast$bandtogether`.* TO 'radagast'@'%' |
+---------------------------------------------------------------------+
4 rows in set (0.00 sec)