MySQL: Cannot create user account after given root a password

Question

I install the MySQL in my EC2 instance, then I give to root a password.

Now I'm trying to create an user to localhost domain and '%' domain too. It was fine to create the user:

CREATE USER 'valter'@'localhost' IDENTIFIED BY '******';

But when I try to grant it some privilegies :

GRANT ALL PRIVILEGES ON *.* TO 'valter'@'localhost' WITH GRANT OPTION;

Gives me the follow error:

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

Here it says :

shell> mysql --user=root mysql If you have assigned a password to the root account, you will also need to supply a --password or -p option, both for this mysql command and for those later in this section.

But how it should look like the command then ?

What I'm doing wrong here ?

I would like to create an user that have access to localhost and external network too.

Ian Hunter · Accepted Answer · 2012-04-04 21:52:30Z

1

This is an issue with EC2, not MySQL. Here's a relevant forum entry:

The issue is that the RDS instance does not have superuser rights so I can't "grant all privileges" to any user.

I was able to get my application to work by creating the user with the specific rights that I need (insert, update,create, etc)

This forum discussion may also be worth looking through:

https://forums.aws.amazon.com/thread.jspa?threadID=64618

answered Apr 4, 2012 at 21:52

Ian Hunter

9,86413 gold badges63 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yahel Over a year ago

Is this correct? It seems like this answer is for Relational Datastore, but the question is about having installed MySQL on an EC2 instance.

Collectives™ on Stack Overflow

MySQL: Cannot create user account after given root a password

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related