Mysql remote connection

[Crane]

While connecting to a mysql connection on another server I get an access denied error. I've made sure that the user can actually login from the localhost and can access the tables. Why would I get this error?

[Crane]

Figured this out - (this is actually the project that went sour in C# forum)

I had to grant access to the user from my IP address.

[Crane]

This is how:

GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";
FLUSH PRIVILEGES;
exit;