…From yesterday to today, my database connection stopped working. I can connect to my remote database thru Workbench but not using Wappler. I’ve deactivate my firewall and tried a few things on my server but to no avail. The reason I ended up trying Wappler was because I didn’t appreciate the way Dreamweaver abandoned connectivity to remote MySQL instances. I’m running Windows 10 on a Dell Precision Workstation. It was working yesterday before today’s updates. Thanks.
Steps to reproduce
1.Tried to run the database connections that I create yesterday that stopped working today. No server changes happened and I can connect remotely from MySQL 8 Workbench.
Hello,
What server model are you using? What type of project?
Where do you have an issue connecting to the database - is it the database manager or your server action > globals > database connection?
And what is the exact issue as “database connection stopped working” could be anything, do you see any errors?
I get a more descriptive error when I use database manager. I’ve seen this error before. Let me make a change to see if it makes a difference. My database server listens to local host but I had made a change yesterday. I have switched back and forth trying to trouble shoot this but I never tried Database Manager.
There is a difference between the server connect connection and the database manager.
So the server connect makes its connection from the server your project is set up to. It uploads a .php connection file there and connects from there.
The connection made from the database manager is the same as if you are using the Workbench tools - it makes a direct connection to the database, not through your web server.
So the error you see in the server connect connection is probably because you’re not allowed to connect remotely from this server/ip to the database.
So I can connect thru Database manager to my local instance of MySQL but not to my remote. The error I’m getting suggests that it’s a permission problem on the server. I would have never tried Database Manager so thank you for your help. Now I need to figure out how to populate a Select using an list array. I’m in day 2 of my 14 day trial but see the potential of Wappler. I used to design web applications and Wappler eliminated all of the nonsense with buying Webassist or DMXZone even though I wish Wappler wasn’t a monthly subscription. Thanks again.
