Dear sir, I am facing this error. How to resolve it ? 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 ‘mysqlroot’' at line 1
Dear sir, when I give these two command I face this error. grant all privileges on *.* to 'root'@'localhost' identified by ‘mysqlroot’; granted all privileges on *.* to 'root'@'%' identified by ‘mysqlroot’; 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 ‘mysqlroot’' at line 1
Hi Munwar, I haven't used GRANT command in this tutorial. You might be getting this error because, you are trying to create a new user and give privileges. You are using incorrect command. Here is the command to add new user and assign privileges. CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON *.* TO 'admin'@'localhost'; I hope it help. Regards, Ankur
👍
Thank you Fabian 😊🙏
Very Helpful. Thank you!
Thank you Pat for the feedback. Glad to know the tutorial was helpful to you. 😊🙏
Since I installed dual boot ubuntu/windows, I made some mistakes during my MySQL installation. So, thank you very much !
You are welcome Thomas 😊🙏
Gracias carnal, very complete and minucious procedure, i will follow you
Thank you Oscar for the positive feedback and subscribe, I appreciate it 😊🙏
Thanks, I was able to get rid of mysql.
Great. Glad to know the tutorial was helpful to you 😊 Thanks Renan for the feedback, I appreciate it 🙏
Dear sir, I am facing this error. How to resolve it ?
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 ‘mysqlroot’' at line 1
Check my response to your other comment.
Dear sir, when I give these two command I face this error.
grant all privileges on *.* to 'root'@'localhost' identified by ‘mysqlroot’;
granted all privileges on *.* to 'root'@'%' identified by ‘mysqlroot’;
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 ‘mysqlroot’' at line 1
Hi Munwar,
I haven't used GRANT command in this tutorial. You might be getting this error because, you are trying to create a new user and give privileges.
You are using incorrect command. Here is the command to add new user and assign privileges.
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'admin'@'localhost';
I hope it help.
Regards,
Ankur