10.3.22-MariaDB-0+deb10u1

[@Func]

does there have some components can access database (10.3.22-MariaDB-0+deb10u1 ). thanks !

[dogriz]

I have no problem accessing MariaDB 10.3.23 on linux with TMySQL57Connection.

[PascalDragon]

MariaDB 10.3.22 should be compatible with the MySQL 5.7 client. Thus as dogriz wrote you can use TMySQL57Connection.

[devEric69]

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:

Code: Pascal  [Select][+][-]

1. object MySQL57Connection1: TMySQL57Connection
2.   Connected = True
3.   LoginPrompt = False
4.   DatabaseName = 'licenses'
5.   KeepConnection = False
6.   Params.Strings = (
7.     'Port=3306'
8.   )
9.   Password = 'root'
10.   UserName = 'root'
11.   CharSet = 'utf8'
12.   HostName = 'localhost'
13.   SkipLibraryVersionCheck = True
14.   left = 104
15.   top = 24
16. 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.