Sql Syntax Error for Grant All



0

I am getting sql syntax error for the following statement.  What am I doing wrong?  This is the same syntax used by Karan in the class room.

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

 

 


3 Answer(s)


0

Hi Sohail,

What is the error you are getting??

 


0

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

 


0

Hi Sohail,

Try the below command:

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

 

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password