That’s certainly the simplest way, and it’s probably fine for an intranet that’s behind a firewall, but it’s not safe for a a public-facing application, which is what this is.
But thanks for the reminder. -David Schwartz > On Feb 24, 2023, at 7:34 AM, techli...@phpcoderusa.com wrote: > > 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
