When I try to add a new user with
grant all privileges on retrosias.* to 'rs3'@'%' identified by 'a';
I can't even connect locally :
ERROR 1045 (28000): Access denied for user 'rs3'@'localhost' (using password: YES)
If I add the same user using
grant all privileges on retrosias.* to 'rs3'@'localhost' identified by 'a';
then I can connect locally but my real need is to connect from any computer.
My server version is
Server version: 5.5.28-0ubuntu0.12.04.3 (Ubuntu)
And I verified that users added before can still connect from anywhere (so not a firewall problem).
Where's my error ? Or what could be a workaround ?