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.
You do have a syntax error, but it’s not with the exclamation points.
GRANT ALL ON *.* TO root@'%' ...
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.