Sql Syntax Error for Grant All


3 Answer(s)


Hi Sohail,

What is the error you are getting??

 


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 'root' WITH GRANT OPTION' at line 1

 


Hi Sohail,

Try the below command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.47.128' IDENTIFIED BY 'root' WITH GRANT OPTION;