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, 2020 in Big Data Hadoop by akhtar
• 38,210 points
12,559 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, 2020 by MD
• 95,300 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,170 points
205 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
1,011 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
• 65,950 points

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

Error: Couldn't properly initialize access to HDFS internals. Please update your WAL Provider to not make use of the 'asyncfs' provider.

Hi@akhtar, I think you are trying to use AsyncFSWAL for HBase-2.x as ...READ MORE

answered Apr 30, 2020 in Big Data Hadoop by MD
• 95,300 points
577 views
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 8, 2020 in Big Data Hadoop by MD
• 95,300 points
410 views