Hello I am having some trouble getting this to work for me.
I need to temp. allow access to all ips to remote mysql connection.
I have centos and cant get the syntax right for some reason.
mysql> grant all on this_db.* to userx@'%' identified by pass;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pass' at line 1