Ok, so i've been trying to figure out a few things via googling on the web and i'm pulling my hairs out.
1) when i try to move my database configuration out of my python script into a separate file for cleaner code and structure, i cannot connect to the database even though it was the same connections as that in the python script.
2) Is there a way to move the SQL database directly off the pi and each time the script runs, it accesses data from a remote sql database that i plan to host on a windows 10 machine else where?
I know i'm supposed to comment out the "bind address" property in the mariadb configuration file and restarted sql service. I've done that but now i'm confused as to what or where to put the connection details and how to actually go about connecting to the sql database stored in another server and use that database for verification work in the script.
Sorry if this has been asked before. I'm just trying to create better structures around codes. Any help is appreciated as i do not want to screw up any configuration files on the pi.