How to setup a remote connection?

Wappler General Need Help
1

OS info

  • Operating System : Windows 10.0.19041
  • Wappler Version : 3.6.1

Problem description

…Trying to get database manager working on new site.
Under database connections the database tests successful

image
image540×600 9.59 KB

but under database manager i get error unable to connect
image
test same connection under databse manager I get
image

Steps to reproduce

  1. Created new php site on hostgator hosting
  2. added target and tested ok.
  3. added database connection, ran into this issue

report_2020-11-18_12-19-42.zip (53.9 KB)

2

Hi, the Database Manager uses a direct connection (not a connection from your target as server connect does) so you are making a request to 127.0.0.1:3306 - which is actually your local machine, not to the remote database - that's why you see this error.
You need to edit the settings of the remote connection to point to your remote database.

3

when I use the ip address i get this
image

4

You should be using the remote IP/hostname of your database (not target/website one). Make sure you are entering the correct IP.

5

OK thanks. I was able to connect so I’m finally seeing the Database manager for the first time ever!

My database IP is the same as my site ip but in this instance I had a space in front of the ip address (ugh)

Next I will try to figure out why my other 3 sites with functioning database connections are not seen in Database manger