This morning, my connection to my local database worked fine. I changed it to my remote one for an upload, which worked fine. Now I tried to change it back to the local one and I can’t access any databases any more…
The local database is running, I can access it with phpmyadmin and MySQL Workbench.
I haven’t changed any access information in the database.
I’ve restarted my laptop.
After about a minute I am getting the message “Error using this database Connection! Empty Response!”
I can’t access the remote database any more either.
Those are great little error messages… the XXX is from my snippet templates that I search and replace! You caught me in the middle of some of those…
I just don’t understand the databsae access issue… it was working fine earlier this morning… I’ve not changed anything in the database, and if I had, then MySQL workbench wouldn’t be logging in…
@Antony
Usually database servers don’t allow remote connections. So what Wappler does is - it uploads the connection file to the selected target and calls the database connection from there.
So when your target is set to remote, and the db connection info is set to your local DB then what happens is - Wappler uploads the localconnection to yourremotehost.com and calls it from there.
The result is: yourremotehost.com/dmxConnect/modules/Connections/local.php and local.php points to some local db server
That is wrong and you should not expect this to work or do it like that. That is why there are different targets…