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

Question

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

Answer 1

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