Welcome, Guest. Please login or register.
Did you miss your activation email?

Author Topic:  [Solved] Can not connect to MySQL-Server  (Read 1396 times)

Offline mash

  • User
  • Posts: 47
[Solved] Can not connect to MySQL-Server
« on: 2021/01/05, 13:29:36 »



Situation:

Server with mysql database (debian sid) mySQL-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



Code: [Select]
mysql -V
mysql  Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using  EditLine wrapper

The exception thrown is just: "Server connect failed. with value (True)"


I can't find anything related to mysql in the logs (dmesg, journalctl, mysql/error.log (neither server nor clients)


So it is rather strange
Any help apreciated where I could search for the culprit

-----------------------

The solution was the /etc/mysql/mysql.conf.d/mysqld.cnf on the server where I had to uncomment the line
bindadress=127.0.0.1

don't know how it got there
« Last Edit: 2021/01/05, 16:52:52 by mash »
when it was hard to write it should be hard to read