Originally Posted by szboardstretcher
Tips on how to do this?
grant read, select on a.* to 'a'@'a' identified by 'dd[$33cc<D';
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 'read, select on a.* to 'a'@'a' identified by 'dd' at line 1
I don't think it has to do with password characters, there is no "read" priv to GRANT.
Depending on MySQL version, look here
for GRANT privs...