I am looking to allow another developer remote access on his machine to the database I am running. I have logged onto MySQL database via the command prompt and have entered the following command
GRANT ALL PRIVILEGES ON *.* TO 'root'@'188.8.131.52' IDENTIFIED BY 'pwd' WITH GRANT OPTION;
I am getting the following error:
check the manual … for the right syntax to use near 'IDENTIFIED BY 'pwd' WITH GRANT OPTION'