Connection to MySQL version 8.0.41 fails.

[iginfo]

Connection to MySQL version 8.0.41 on WEB server, fails using native component or Zeos due to difficulty with dll. Any help to find or configure them?

[marcov]

Can you access it using some SQL explorer/ management? Maybe it is from where you connect, not with what you connect.

[Zvoni]

Can you access it using some SQL explorer/ management? Maybe it is from where you connect, not with what you connect.

....and it doesn't matter if it's a Web-Sever or not...
what matters is,
1) where that server is, and if you have to go through a Router/Firewall or if it's on a local LAN
2) Is the Server configured correctly? As in: Is the mysqld-daemon listening on the correct NIC?

[iginfo]

Can you access it using some SQL explorer/ management? Maybe it is from where you connect, not with what you connect.

Yes I can with HeidiSQL, which does it all.

[Zvoni]

Can you access it using some SQL explorer/ management? Maybe it is from where you connect, not with what you connect.

Yes I can with HeidiSQL, which does it all.

And my Questions above?

[iginfo]

Can you access it using some SQL explorer/ management? Maybe it is from where you connect, not with what you connect.

Yes I can with HeidiSQL, which does it all.

And my Questions above?

HeidiSQL accesses the database remotely from my client machine and everything works. So all configuration and path possibilities are answered.

[Zvoni]

Can you access it using some SQL explorer/ management? Maybe it is from where you connect, not with what you connect.

Yes I can with HeidiSQL, which does it all.

And my Questions above?

HeidiSQL accesses the database remotely from my client machine and everything works. So all configuration and path possibilities are answered.

And you are definitely using the same Parameters (IP, Port, Credentials, optional SSL etc.)?
In HeidiSQL, fire off "SELECT VERSION();" and post it here.

btw: Is your Lazarus/FreePascal-Client-Program 32-Bit or 64-Bit?
because you need the clientlib in the correct bitness for your target as well in the correct bitness for Lazarus itself (if you want to use design-time connection), nevermind in the correct version

[rvk]

Yes I can with HeidiSQL, which does it all.

HeidiSQL uses it's own local libraries (dll's).
So how did you install the MySQL client libraries for Lazarus ??

[Zvoni]

Yes I can with HeidiSQL, which does it all.

HeidiSQL uses it's own local libraries (dll's).
So how did you install the MySQL client libraries for Lazarus ??

Ouch!
Didn't think of that.
Now the only thing missing is TS saying he's using Ubuntu as Dev-Platform, and installed HeidiSQL as a Snap....

[dseligo]

Can you access it using some SQL explorer/ management? Maybe it is from where you connect, not with what you connect.

Yes I can with HeidiSQL, which does it all.

And my Questions above?

HeidiSQL accesses the database remotely from my client machine and everything works. So all configuration and path possibilities are answered.

Try to use DLLs from HeidiSQL then (copy them to your project's directory). Mind bitness of dll (if you installed 64-bit HeidiSQL, your program has also to be 64 bit).

[iginfo]

HeidiSQL is 64-bit and uses its own dlls locally. I'm not sure if my Lazarus 3.6 is 32 or 64 bits. I think it's 64 bits because the About tab says 32/64 bits. I looked for the dlls on the MySql website, but I'm not sure either. I think the problem could actually be 32/64-bit compatibility. So if someone can point me in the right direction, maybe I can solve it.

[dseligo]

HeidiSQL is 64-bit and uses its own dlls locally. I'm not sure if my Lazarus 3.6 is 32 or 64 bits. I think it's 64 bits because the About tab says 32/64 bits. I looked for the dlls on the MySql website, but I'm not sure either. I think the problem could actually be 32/64-bit compatibility. So if someone can point me in the right direction, maybe I can solve it.

Is this under Windows? Check if you have in your project options, under 'Config and Target': Target OS = Win64, Target CPU family = x86_64.
Then copy DLLs from HeidiSQL to your project's directory.

[paweld]

Is this under Windows? Check if you have in your project options, under 'Config and Target': Target OS = Win64, Target CPU family = x86_64.
Then copy DLLs from HeidiSQL to your project's directory.

By default, these properties are set to “Default” and then you should check the compiler version in Help > About Lazarus. And there, in the last line, it may be, among other things:
- i386-win32-win32/win64 -> 32 bit
- x86_64-win64-win32/win64 -> 64 bit

[jcmontherock]

I got the same problem. Try an older version of libmysql.dll (for ex: 8.0.34).

[iginfo]

I got the same problem. Try an older version of libmysql.dll (for ex: 8.0.34).

From where I can get it?