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 in Big Data Hadoop by Ramesh
238 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 by Gitika
• 25,420 points

Related Questions In Big Data Hadoop

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Why we need to install "ant -Dhadoopversion=23" ? What is the use of this?

Hi, We install ant to build pig, If the ...READ MORE

answered Apr 26 in Big Data Hadoop by Gitika
• 25,420 points
48 views
0 votes
1 answer

Update hdfs data before stroring in MySql

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

answered Jan 27 in Big Data Hadoop by Omkar
• 68,160 points
41 views
0 votes
1 answer

Configure Oozie to use MySQL

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

answered Jun 4 in Big Data Hadoop by Karan
57 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
45 views
0 votes
1 answer

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

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

answered Apr 15 in Big Data Hadoop by Gitika
• 25,420 points
83 views