updating database connections with invalid charset

[jefferis]

Hi, I am trying to update php 5 older sites with new connections to   php 8 mysql versions for my client
While i can connect using Navicat and can see all the tables, when I try to update and connect using DMXZone Server Connect or  Webassist DataBridge I am getting an error:

Error using this Database Connection!
Server Response : SQLSTATE(HY000) [2054] Server sent charset unknown to
the client. Please, report to the developers

Any ideas on how to fix this issue?

running php info I found that the site is still operating on php 5.4.x and mysql 5.0.11

[Ben M]

As this is related to third party extensions have you reached out to those vendors with the error to see what they are able to offer?

[jefferis]

yes    I am awaiting responses.   Webassist believes that DW and current connections are not working with older versions of PHP and MySQL. 

[Nancy OShea]

Possibly Related:

https://stackoverflow.com/questions/62873680/how-to-resolve-sqlstatehy000-2054-the-server-requested-...

[BenPleysier]

You will need to update the server, both local and remote, to the new versions.

Another solution is to start using Wappler. Wappler has its own PHP/MySQL built in server for local development so that there is no need to instal an Apache server locally.