MariaDB v11.*

[mirce.vladimirov]

EDIT :  It was my typing mistake,  we dont talk about MariaDB11 but 10.11, sorry about that

I am using Lazarus 2.2.4 under Windows , using SQLDB many years and was connecting to different versions of MySQL 5.* and Mariadb until 10.* and so far all was going well until recently i tried to connect to Maria DB version 11.*  10.11.
I also cannot connect via command line.

I did try the TMySQL80Connection component but it complains that the version is not the expected one and breaks, which is normal when the *.dll file is not the correct one.
I was reading on various web pages, seems like libmysql.dll does not supports connecting to MySQL8 and MariaDB 11  10.11.

There is a component TMySQL80Connection in Lazarus , so I guess that there is a "thing" to be done to connect ?

[rvk]

I did try the TMySQL80Connection component but it complains that the version is not the expected one and breaks...

When using TMySQL80Connection you need to set the SkipLibraryVersion to false.
After that, it shouldn't complain about "expected version".

I'm still puzzled why Lazarus has so many components for MySQL while the changes are not that large between versions and it's a pain if you work with different servers between different users of your program.

[mirce.vladimirov]

Also,
When I tried to connect thru command line (the mysql.exe) connection was not established, I am getting a message

ERROR 1045 (28000): Access denied for user 'myusername'@'myhostsipaddress' (using password: YES)

And right after that I change my directory do MySQL Workbench's and use the "mysql.exe" located in that directory :

cd "\Program Files\MySQL\MySQL Workbench 8.0 CE"

and it just connects.