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) method. See the suggested answers in this link: https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server/50961428 Hope this helps. Kind regards, Panos -- On Wed, 26 Aug 2020 at 07:30, Todd Fabacher via use-livecode < use-livecode@lists.runrev.com> wrote: > I am using revOpenDatabase with the "MySQL" parameter on LiveCode server. > > I am getting an error: > > *Client does not support authentication protocol requested by server; > consider upgrading MySQL client* > > What can I do?? I am in a real hole as the version of mySQL was updated to > the latest version 8.0 and now LiveCode server is NOT working??? > > > Please advise, > > Todd Fabacher > > PS I never got LC server to open a Postgres Database. I need some help > here. > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
