[Edit Solved] Can not connect to MySQL-Server
lazarus / 16-Databases

----------------------------------------------------------------------
hy · 2021-01-04 15:50

Situation:
Server with mysql database (debian sid) Server version: 5.7.26-1+b1 -
(Debian).

Access with phpmyadmin works on all machines (Win10 and Linux)

Desired:
Access to DB with a self-written program (PL Lazarus).
The program is in productive use since March 2019 but was hardly used
in December. Last new entry in the database was on 7.12.2020
(timestamp in the record).
Now I don't get a connect to the DB from any of the PCs also the
exceptions that are thrown don't give any hint.
I have deactivated Apparmor

Edit: Now (after setting skiplabraryversion to FALSE) I get
TMySQL57Connection can not work with the installed MySQL client
version: Expected (5.7), got (8.0.22).
On my commandline when checking the version I get
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 mysql
-Vmysql  Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using  EditLine
wrapper [Edit 2] I have downgraded the library to mysqlclient20. I am
not getting the version mismatch now but "Server connect failed. with
value (True)"

So it is rather strange
Any help apreciated
---------------------------------
The solution was the /etc/mysql/mysql.conf.d/mysqld.cnf on the server
where I had to uncomment the line
bindadresse=127.0.0.1
(don't know ho it got there)