Reputation: 6007
When I try to grant privileges to a user with an admin user I get this error message:
GRANT ALL PRIVILEGES ON `awesomeproject`.* TO 'awesomeproject'@'localhost';
Result:
ERROR 1044 (42000): Access denied for user 'mygoodadmin'@'localhost' to database 'awesomeproject'
If I check the current user's privileges with this command:
SHOW GRANTS FOR 'mygoodadmin'@'localhost';
I get this result:
+------------------------------------------------------------+
| Grants for mygoodadmin@localhost |
+------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mygoodadmin'@'localhost' |
| GRANT ALL PRIVILEGES ON `%`.* TO 'mygoodadmin'@'localhost' |
+------------------------------------------------------------+
What I missed?
Upvotes: 1
Views: 1877