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 *.* [email protected]'%' 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 [email protected]'%' ...

View the full question and any other answers on Server Fault.

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