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?