I have some PHP code, running on my machine which connects with a remote MySQL database. Before deploying the code I test is locally. When deployed it then sits on a hosted server and accesses the same database.
There is no conditional code and this was all working well until recently. I needed to enhance the appliation and made the changes but now it fails to connect giving error
Unable to communicate:Unknown MySQL Server Host 'www.XXX.com' (10022)
The structure of the application is that page 1 gets the user/password and uses POST to get to page 2 which does the database connection, saves the connection information to session variables and displays some data and gives processing options. One of the processing options displays page 3.
I made changes on page 3, and now get this error when testing locally. This happens on page 2 when it, and the include files have not changed from when it did work.
When the application is deployed to the server it connects fine, so the code would seem to be OK, so I havent posted that here.
I can also connect to the database from my machine using SQLyog, using the same user id password combination, so a domain security problem should be ruled out
I am just asking for some other suggestions on what to investigate to try and resolve the problem as I dont want to put untested code on the server.
