David,

Seems like what you are attempting would be routine.  (remote MySql)

I found this :: 
https://stackoverflow.com/questions/27916503/lamp-setup-with-remote-mysql

Hope it helps.

Keith


On 2023-02-24 03:00, David Schwartz via PLUG-discuss wrote:
> I’m building a web app that requires a membership with various levels. 
> There will be a front-end (the web app) and a back-end on a Windows 
> server. I’m thinking about putting the user DB on separate server.
> 
> I have this tool that lets me build apps using php and MySQL really 
> easily to handle my basic admin needs (AppGini) and I’m thinking of 
> using that to create the member’s DB and maintain it.
> 
> But if it’s on another server, then I’ll need some kind of interface to 
> it so the back-end service can talk to it and do basic user-access 
> things, like login/logout, change their pwd, get their basic account 
> details, maybe deal with payments.
> 
> I’ve done a bit of poking around and it seems that in a Linux server 
> with Apache, you need a little “router” that takes the incoming 
> requests and routes them to endpoints by calling some php methods that 
> access the DB. Or maybe it implements them itself.
> 
> It looks like there may even be something like that included in MySQL.
> 
> I have a shared hosting account that runs cPanel and WHM, so I don’t 
> have access to the shell (well, it’s an option per account in WHM, and 
> I’ve asked, but generally not).
> 
> This sort of thing is something I’ve had the dubious luxury of having 
> managed everywhere I’ve worked by an IT Dept, but this is for me and I 
> haven’t done this stuff in a long time. This is mainly for Dev + Test; 
> I’ll set up a dedicated server when I go into production.
> 
> So I’m curious what y’all think of this approach.
> 
> Some may ask, “Why not some cloud service, like AWS or …?” My only 
> answer is: because this is what I know right now. Convince me 
> otherwise.
> 
> I’d actually be open to a 3rd-party service if you know of any that’s 
> free or really cheap for Devs to set up.
> 
> -David Schwartz
> 
> 
> 
> 
> ---------------------------------------------------
> PLUG-discuss mailing list: PLUG-discuss@lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> https://lists.phxlinux.org/mailman/listinfo/plug-discuss
---------------------------------------------------
PLUG-discuss mailing list: PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
https://lists.phxlinux.org/mailman/listinfo/plug-discuss