ERROR 1227 42000 Access denied you need at least one of the CREATE USER privilege s for this operation

Question

I am new to mysql and Oozie, so while trying to create user through this command:

create  user 'oozie' identified by 'edureka'

And this error came up:

 ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation.

How can I come out of it?

Answer 1

Hi,

You can follow some steps to remove this error listed below:

First, login in into mysql in your shell with the help of the command:

       mysql -u root

Then run this command: 

select user from mysql.user;

And then run this command:

create  user 'oozie' identified by 'edureka'

Then there will be no error, I hope.