CODEWITHSUNDEEP
mysqldatabaseprivileges
Ruslan
Ruslan

Reputation: 951

Grant privileges to an existing user in MySQL

Trying to grant privileges to an existing database user using

GRANT SELECT, INSERT, UPDATE ON myschema.* TO 'OptimusPrime'@'cybertron';

But I keep getting

1410, 'You are not allowed to create a user with GRANT'

I'm stumped since I'm certain that user OptimusPrime exists in the database (!). I verified it using

select * from mysql.user;

and indeed, OptimusPrime is there. I'm stumped. Anyone as a clue on why I keep getting this? I'm not trying to create a new user

EDIT: I'm using the root user

EDIT2: Tried doing that to root user. Getting same error. I'll try to reinstall the server. Something is fishy. I'll update once I've done that

Upvotes: 3

Views: 3093

Answers (1)

MrLizzard
MrLizzard

Reputation: 178

To execute this command, you need to execute the sql query as admin, or with user granted to execute a GRANT query.

You can connect with root user, and try to execute 

GRANT SELECT, INSERT, UPDATE ON myschema.* TO 'OptimusPrime'@'cybertron';

and the result will be better.

Upvotes: 2

Related Questions