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
(text/plain)