10.3.22-MariaDB-0+deb10u1
lazarus / 16-Databases

----------------------------------------------------------------------
@Func · 2020-05-22 04:13

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

----------------------------------------------------------------------
dogriz · 2020-05-22 07:01

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

----------------------------------------------------------------------
PascalDragon · 2020-05-22 07:04

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

----------------------------------------------------------------------
devEric69 · 2020-05-22 09:01

Quote from: PascalDragon on May 22, 2020, 09:04:25 amMariaDB 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.fr
eepascal.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][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i 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 = 24end
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.