Hi,
I'm connecting as root to my DB from a GCE instance. I've added a user. However, it won't let me GRANT that user any privileges. I keep getting Error 1044 Access Denied.
You can see that I have a 'testuser'@'%':
mysql> SELECT User, Host, Password FROM mysql.user;
+----------+-----------+-------------------------------------------+
| User | Host | Password |
+----------+-----------+-------------------------------------------+
| root | localhost | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| root | % | * LSKDFLKJDFSLKJSDFLJKLKSJFDJKLJKLFSDLJKF |
| testuser | % | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |
+----------+-----------+-------------------------------------------+
Here are some of the things I've tried:
mysql> GRANT ALL ON drupal.* TO 'testuser'@'%';
ERROR 1044 (42000): Access denied for user 'root'@'%' to database 'drupal'
mysql> GRANT ALL ON `%`.* TO 'testuser'@'%';
ERROR 1044 (42000): Access denied for user 'root'@'%' to database '%'
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON drupal.* TO 'testuser'@'%';
ERROR 1044 (42000): Access denied for user 'root'@'%' to database 'drupal'
Note that I was able to create the drupal db and add tables to it (as root). Any ideas?
Thanks!