-2

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'@'71.142.244.19' 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'
New contributor
Hector is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Oops... sorry. Read GRANT Statement and study CORRECT syntax. IDENTIFIED BY 'pwd' is taken from CREATE USER. – Akina Feb 14 at 9:12

Your Answer

Hector is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.