ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

[Matt Visich]

Hello All,
I have run into an issue that I cant seem to find a solution to.
I am currently running a database on amazons RDS. So root at localhost is not accessible.
I'm working on fixing our current user/password policy. Currently we have a root user that has a host %. I am working on getting rid of this security issue.


mysql> CREATE USER 'temp_1'@'%' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.09 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'temp_1'@'%';
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

The user I am logged in looks like this via the select mysql.users

*************************** 3. row ***************************
Host: %
User: root
Password: apassword
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Reload_priv: Y
Shutdown_priv: N
Process_priv: Y
File_priv: N
Grant_priv: Y
References_priv: Y
Index_priv: Y
Alter_priv: Y
Show_db_priv: Y
Super_priv: N
Create_tmp_table_priv: Y
Lock_tables_priv: Y
Execute_priv: Y
Repl_slave_priv: N
Repl_client_priv: Y
Create_view_priv: Y
Show_view_priv: Y
Create_routine_priv: Y
Alter_routine_priv: Y
Create_user_priv: Y
Event_priv: Y
Trigger_priv: Y
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0

mysql> show grants \G
*************************** 1. row ***************************
Grants for root@%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD 'a password' WITH GRANT OPTION
1 row in set (0.10 sec)

It looks like I should have permission to do this change....
any help is much apreciated!
Thanks!