DB connection steps

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:

image858×611 17 KB

Target:

image858×632 18.9 KB

And i get this when creating the connection:

image984×775 42.7 KB

Thanks!