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
• 10,330 points
1,576 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
• 22,520 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,060 points
71 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
413 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
• 29,170 points

edited Aug 7, 2019 by Gitika 189 views
0 votes
1 answer
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 Feb 13 in Big Data Hadoop by MD
• 22,520 points
89 views