mysql allow remote root special characters

thevoipman asked:

I’m trying to have !! in my password for mysql remote login but it won’t take it when I execute the following command:

grant all on *.* root@'%' IDENTIFIED BY '1234c00l!!';

It’s telling me that I have a syntax error. Is there any other way to allow remote login with password with special characters? Any kind of help I can get on this is greatly appreciated.

My answer:


You do have a syntax error, but it’s not with the exclamation points.

You’re missing TO:

GRANT ALL ON *.* TO root@'%' ...

View the full question and answer on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.