ERROR 1064 (42000): You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'Hivepass70@'' at line 1

+1 vote

Hello everyone,

I created one user in mysql and tried to give access, but I am getting the below error.

GRANT all on *.* to 'hiveuser1'@localhost identified by 'Hivepass70@';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'Hivepass70@'' at line 1

How can I solve it?

Thank You

Feb 13 in Big Data Hadoop by akhtar
• 33,120 points
6,434 views

1 answer to this question.

0 votes

Hi@akhtar,

I don't what is wrong with your command. But you can use the below command to create user.

$ CREATE USER 'hiveuser1'@'localhost' IDENTIFIED BY 'Hivepass70@'

$ GRANT ALL PRIVILEGES ON  *.* to 'hiveuser1'@'localhost';

Thank You

answered Feb 13 by MD
• 78,020 points

Related Questions In Big Data Hadoop

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
109 views
0 votes
1 answer

How to add mysql database for Hue Query app?

Hi. To add mysql database in the config, open ...READ MORE

answered May 27, 2019 in Big Data Hadoop by Vasu
599 views
0 votes
1 answer

Error: Hive show tables does not display table "sqooptest" , which was imported by SQOOP

Hi, You can follow the below-given solution. Just enter ...READ MORE

answered Aug 7, 2019 in Big Data Hadoop by Gitika
• 48,800 points

edited Aug 7, 2019 by Gitika 394 views
0 votes
1 answer
0 votes
1 answer

I have to ingest in hadoop cluster large number of files for testing , what is the best way to do it?

Hi@sonali, It depends on what kind of testing ...READ MORE

answered Jul 7 in Big Data Hadoop by MD
• 78,020 points
192 views