DB connection steps

Wappler General
1

Good evening all,

Despite all my efforts and readings, I’m unable to create my first DB connection. Truth is, I don’t understand the Creating Database Connections with the Database Manager page.

I successfully created my FTP connection - to my remote server, hence the Target: production
I have a full 20-table MySQL DB ready on that server.

Target: local has created all the assets, css, etc folders in my local machine. But my DB is out there in my remote server.

So two targets: local (my laptop) and production (my remote DB). I don’t use Docker.

Where do I take it from there please? Unique Ideas’ DB connection tutorial is great but I still don’t get it.

Project settings:

image
image858×611 17 KB

Target:

image
image858×632 18.9 KB

And i get this when creating the connection:

image
image984×775 42.7 KB

Thanks! :face_with_thermometer:

2

Is your server setup to run php? It doesn’t seem so…
Or your web root folder doesn’t match

3

It is php web server version 7.3.6. I used the phpMyAdmin interface (v4.9.4) to create my DB.

RE web root folder, please elaborate. I was hesitant about this part so that might be the issue here.

4

In your ftp settings you have to give a remote folder that should match your web root

5

Thanks much for your speedy support, honored to be attended by the ceo himself :slight_smile:
But I don’t understand your instruction. I don’t see anything wrong in the web root settings and what “matching folder” you are talking about.
On my Local target, I have the folder C:\Users\User\project_pltfm (with all the dmx, css, assets…subfolders)
On my remote DB server, I have to use /www/ folder as per their instructions.

Anyway, I somehow fixed the problem by changing the DB name.