[fpc-devel] MySQL Error 2026 HY000 when connection to MySQL docker container (WSL2)

[Michael Van Canneyt]

Hi,

First of all: FPC does not support MySQL 8. The headers must be reviewed.

The ErrorNo 2026 (HY000) points to a SSl error, I doubt that this is an
error in FPC itself. Maybe extra params need to be set.

Michael.

On Fri, 12 Jun 2020, Pascal Riekenberg wrote:

> Hi,
>
> does anyone experience similar problems
> when connecting to a MySQL 8 docker container (WSL2)?
>
> I get ErrorNo 2026 (HY000) on connect. While mysql command and MySQL Workbench work as expected.
>
> fTransaction := TSQLTransaction.Create(Application);
> fDatabase := TMySQL57Connection.Create(Application);
> with fDatabase do begin
> HostName := '127.0.0.1';
> Port := 3311;
> DatabaseName := 'sus';
> UserName := 'sus';
> Password := 'sus';
> Transaction := fTransaction;
> try
> Connected := true;
> except
> on E:Exception do begin
> fErrorMessage := E.Message;
> end;
> end;
> end;
>
> Lazarus trunk, FPC trunk.
>
> Pascal
>