I want to connect My existing MYSQL database hosted with namecheap with wappler's node.js
the direct connection failed so I am connecting via SHH which has shown success connection but the data can not be queried when I use like for example a read API on a page, it doesnt read the data yet the tables already contain data at the back end
here is my connection
connection showssuccess message and tables pulled from the server but their contents can not be Read, updated, etc all SCRUD functions cant work,
I needed to rebuild the digital app using Node.js with layout pages as I fix the php bug side
But the Node.js database connection to MYSQL is failing
Kindly guide on how I can over come that problem
Hello! First of all, check your project folder which has a space on the name, I recommend on new ones, just use underscore or camelCase..
Take on consideration that you also need to configure database under globals:
Direct database which is on your 2nd post allow you to see and edit the database.
Database connector under globals allows you to connect it to your API's (like a query, insert etc)
Not sure which bugs are you referring to, but if you’re talking about your other topic with user being logged out, there is no bug there, but it all leads to user errors.
This may be the result of namecheap's database security preventing remote connections as an anti hacking measure.
Have you checked with their tech support to see if the allow this as many don't.
