the remote db is set up and privileges have been set for the user acct to connect to it:
GRANT ALL PRIVILEGES ON myDB.* TO 'myUser'@'123.123.123.123' IDENTIFIED BY 'secretpassword' REQUIRE SSL;
When I try to connect, I get the "mysql_connect(): Access denied for user...(using password: YES)" error. What's the command to connect via ssl?
Also, just to confirm, if 123.123.123.123 is the IP of the Apache server which is serving the website, having 123.123.123.123 for mysql in the hosts.allow file on the server hosting the db is enough, right?
Thanks,
Biggus