Direct access to MySQL on mobile

[panagiotis merakos]

Hello all,

Off-topic (or maybe not) - it is not suggested to access the MySQL database
directly from the client app, either it is a Desktop app or a mobile one.
Accessing the DB directly means the credentials are stored in the app, so
theoretically a malicious actor could extract those from the app.

The recommended approach is to have the client app talk with the DB via a
LC Server .lc script, which will handle all the confidential info. So the
credentials will never leave the server. The flow is the following:

The client app talks to the server -> the server connects to the DB and
does the SQL query -> the DB returns the result to the server -> the server
returns the result back to the app.

Hope this helps.

Kind regards,
Panos
--

On Wed, 2 Jul 2025 at 18:19, Klaus major-k via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Hi Bob,
>
> > Am 02.07.2025 um 17:13 schrieb Bob Sneidar via use-livecode <
> use-livecode at lists.runrev.com>:
> > Yes, but the wifi could be routed, in which case there can still be a
> firewall issue.
>
> I'll let him check this, thank you.
>
> > Bob S
> >
> >> On Jul 2, 2025, at 8:10 AM, Klaus major-k via use-livecode <
> use-livecode at lists.runrev.com> wrote:
> >>
> >> Hi Bob,
> >>
> >>> Am 02.07.2025 um 17:04 schrieb Bob Sneidar via use-livecode <
> use-livecode at lists.runrev.com>:
> >>> I doubt that the issue is encryption. The error is that the host is
> unknown. I would check to make sure your android has good router and dns
> settings, and that port 3306 is not firewalled somewhere.
> >> the tablet he tested on is in the same network (WiFi) as the Mac and PC
> with LC where this works.
> >>> Also try and ping the hostname from somewhere outside the hosts local
> network, it doesn’t matter where. You should at least get DNS resolution.
> If not, your public DNS records for the host are not good.
> >>>
> >>> Bob S
>
> Best
>
> Klaus
> --
> Klaus Major
> https://www.major-k.de
> https://www.major-k.de/bass
> klaus at major-k.de
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>