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
5,520 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
• 37,090 points

Related Questions In Big Data Hadoop

0 votes
1 answer
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,030 points
92 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
182 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,810 points
82 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
• 37,090 points
486 views