Having managed to get Delphi to connect to MySQL (see

The downside of this is that you won't be able to use the caching_sha2_password authentication in other scenarios (ie not from Delphi). If that's acceptable, then this is the way to go.

However, this will still leave you with a 64-bit version of libmysql.dll. If you go to the MySQL download page for version 5.1, then you can download that version as a zip file. The lib folder in there includes the DLL, as well as a correspondingly named .lib file. I don't know if you need to, but I copied both of these into C:\Program Files\MySQL\MySQL Server 8.0\lib (renaming the existing ones first!), and restarted Delphi, and all was well.

Hope that helps.