<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
Hi,
<br>
</div>
<div>
<br>
</div>
<div>
does anyone experience similar problems
<br>
</div>
<div>
when connecting to a MySQL 8 docker container (WSL2)?
<br>
</div>
<div>
<br>
</div>
<div>
I get ErrorNo 2026 (HY000) on connect. While mysql command and MySQL Workbench work as expected.
<br>
</div>
<div>
<br>
</div>
<div>
<span style="font-family: courier new, courier;"> fTransaction := TSQLTransaction.Create(Application);</span>
<br>
<span style="font-family: courier new, courier;">fDatabase := TMySQL57Connection.Create(Application);</span>
<br>
<span style="font-family: courier new, courier;">with fDatabase do begin</span>
<br>
<span style="font-family: courier new, courier;"> HostName := '127.0.0.1';</span>
<br>
<span style="font-family: courier new, courier;"> Port := 3311; </span>
<br>
<span style="font-family: courier new, courier;"> DatabaseName := 'sus'; </span>
<br>
<span style="font-family: courier new, courier;"> UserName := 'sus'; </span>
<br>
<span style="font-family: courier new, courier;"> Password := 'sus'; </span>
<br>
<span style="font-family: courier new, courier;"> Transaction := fTransaction;</span>
<br>
<span style="font-family: courier new, courier;"> try</span>
<br>
<span style="font-family: courier new, courier;"> Connected := true;</span>
<br>
<span style="font-family: courier new, courier;"> except</span>
<br>
<span style="font-family: courier new, courier;"> on E:Exception do begin</span>
<br>
<span style="font-family: courier new, courier;"> fErrorMessage := E.Message;</span>
<br>
<span style="font-family: courier new, courier;"> end;</span>
<br>
<span style="font-family: courier new, courier;"> end;</span>
<br>
<span style="font-family: courier new, courier;">end;</span>
<br>
</div>
<div>
<br>
</div>
<div>
Lazarus trunk, FPC trunk.
<br>
</div>
<div class="io-ox-signature">
<p>Pascal<br></p>
</div>
</body>
</html>