Skip navigation links

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


Advanced Search

ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
Posted by: Matt Visich ()
Date: October 15, 2012 03:36PM

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!

Options: ReplyQuote


Subject Written By Posted
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES) Matt Visich 10/15/2012 03:36PM
Re: ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES) Devart Team 10/16/2012 12:26AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES) Matt Visich 10/16/2012 09:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.