mysql permissions not working

[Red Squirrel]

I'm trying to allow a server to access an external mysql db but no matter what I try it just keeps saying access denied. I even tried adding % as the host so it allows any host. It works on other hosts but not the host I want it to work on. SQL permissions seem to be very flaky in general.

Is there a way I can get this to work? It if matters server trying to access the SQL server is virtualized on the SQL server. I can telnet to the port fine.

 

[Red Squirrel]

Got it working after blindly clicking everywhere a bit more. I wish these were simpler and more to the point.

 

[XOR != OR]

You need to reload mysql after making permission changes for the changes to take effect. Do that, they are rock solid.