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

0 votes

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?

Jun 19, 2019 in Big Data Hadoop by Ramesh
31,002 views

1 answer to this question.

0 votes

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.

answered Jun 19, 2019 by Gitika
• 65,890 points

Related Questions In Big Data Hadoop

0 votes
1 answer

What happens in a MapReduce job when you set the number of reducers to one?

If you set number of reducers as ...READ MORE

answered Jul 31, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
2,042 views
0 votes
1 answer
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27, 2019 in Big Data Hadoop by Omkar
• 69,220 points
754 views
0 votes
1 answer

Configure Oozie to use MySQL

To configure Oozie to use MySQL, open ...READ MORE

answered Jun 4, 2019 in Big Data Hadoop by Karan
1,359 views
0 votes
1 answer
0 votes
1 answer

Using Hadoop for Data Analytics.

Yes, your approach is correct - you ...READ MORE

answered Sep 28, 2018 in Big Data Hadoop by Frankie
• 9,830 points
722 views
0 votes
1 answer
0 votes
1 answer

error: Access denied for user 'sample'@'localhost'.

This kind of error occurs when we ...READ MORE

answered Apr 15, 2019 in Big Data Hadoop by Gitika
• 65,890 points
1,895 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP