MariaDB 10.3.22 should be compatible with the MySQL 5.7 client. Thus you can use TMySQL57Connection.
Thank you,
I have the same problem with a MariaDB 10, and it works for me (nb: but I'm under Windows, before migrating the development under Linux).
My configuration is:
▶ on the database server side:
version: 10.0.29-MariaDB - mariadb.org
charset=utf8
started on localhost and listening at 3306
▶ on the database client side (from the database server's "point of view"):
▪ a client Apache (I work with a WAMP named Uniserver (
https://wiki.freepascal.org/Lazarus_Application_Gallery#Uniform_Server), written in Object Pascal too):
libmysql - version mysqlnd 5.0.12-dev
▪ a client API named libmysql.dll for Lazarus (copied from the my standard installation of UniserverXIII in '...\UniserverXIII\\core\mysql\bin', and pasted into 'C:Windows System32') - version: 10.0.029
From Lazarus, the component resource witten in *.lfm is:
object MySQL57Connection1: TMySQL57Connection
Connected = True
LoginPrompt = False
DatabaseName = 'licenses'
KeepConnection = False
Params.Strings = (
'Port=3306'
)
Password = 'root'
UserName = 'root'
CharSet = 'utf8'
HostName = 'localhost'
SkipLibraryVersionCheck = True
left = 104
top = 24
end
ps1: i've another layer for - mysqli or pdo - Php data access - too, which is named php*mysql*.dll, in order to be able to model a base with PhpMyAdmin (Version : 4.4.15.10, installed with Uniserver also)
ps2: it also works well with Zeos 7.2.6 stable (but it requires the installation and versioning of the zcomponent.lpk package).
ps3: compatibilities between MariaDB and MySQL are written in mysqlconn.inc, line 75.