Ok using IPAddress, UserName and Password (where the MySQL user is set as UserName@%) I can connect to a MySQL DB using my SQLyog.
However running:-
$res = mysql_connect('IPAddress','UserName','Password') or die($strings[“error_server”]);
in PHP on the same machine it fails to connect: I'm tearing my hair out what can be the difference?
I have other DBs that aren't exhibiting this behaviour on the same MySQL server and the only difference is that they are not UTF8 is that the issue?