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

0 votes

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

4 days ago in Big Data Hadoop by akhtar
• 1,440 points
98 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 4 days ago by MD
• 2,750 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
• 68,940 points
51 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
277 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
• 25,830 points

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

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Hi@akhtar, Before setting password in mysql, check the ...READ MORE

answered 4 days ago in Big Data Hadoop by MD
• 2,750 points
14 views
0 votes
1 answer