Strange behavior between Mysql, MariaDB and SSL.

panagiotis merakos merakosp at
Wed Aug 26 10:08:55 EDT 2020

Hello all,

This is because MySQL 8 supports a stronger authentication method based on
SHA256, and this method is used by default.

LiveCode (as well as some other MySQL connectors/clients) do not support
this authentication method yet. In this case, you could configure your
MySQL installation to use the legacy authentication (password encryption)

See the suggested answers in this link:

Hope this helps.

Kind regards,

On Tue, 25 Aug 2020 at 18:41, Bob Sneidar via use-livecode <
use-livecode at> wrote:

> mySQL for which platform? Last I checked, the build for Windows did NOT
> support encryption. There is a special branch that does, but I could never
> get it to work.
> What I came up with is an agent that resides on the SQL server, built in
> Livecode that listens for connections. It then handles the queries locally
> and returns the data.
> The client and Server encrypt the data before sending it using a method
> only I know, so it’s very secure. The communications are done but I haven’t
> done the actual query side yet. That will be a half day’s work at most.
> I think this client server approach is far better than native encryption,
> because I control the method and use a technique where even if someone
> tried brute force, or somehow discovered the key, they still could not
> decrypt the data, and wouldn’t know why.
> Bob S
> On Aug 24, 2020, at 3:25 PM, Heriberto Torrado via use-livecode <
> use-livecode at<mailto:use-livecode at>>
> wrote:
> Dear livecode programmers,
> For a few years we ran an internal app that accessed a MariaDB database
> (no PHP or LiveCode Server middleware, just a raw connection) using SSL.
> The server running the database is old, so we moved to a new one.
> The new one comes with a Mysql 8 Database instead of MariaDB and the SSL
> encryption suddenly stopped working.
> The new MYSQL database has a working SSL encryption cert (Let's encrypt).
> There are the tests:
> *From the server:*
> _______________________________________________
> use-livecode mailing list
> use-livecode at
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:

More information about the use-livecode mailing list