MariaDB v11.*
lazarus / 16-Databases

----------------------------------------------------------------------
mirce.vladimirov · 2023-11-20 09:52

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 · 2023-11-20 09:59

Quote from: mirce.vladimirov on November 20, 2023, 10:52:10 amI 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 · 2023-11-20 10:39

Also,
When I tried to connect thru command line (the mysql.exe) connection
was not established, I am getting a message
QuoteERROR 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 :
Quotecd "\Program Files\MySQL\MySQL Workbench 8.0 CE"
and it just connects.