Connect to MySQL failed
I have a Windows 11 Pro that I use as a server. One PC with Windows 10 Pro connects to the MySQL Server on this Windows 11 Pro server (Version 5.5.50). This worked for years, but after a Windows update I get the following error message:
1.
ExecCmd: SET sql_mode = ''
[FireDAC][Comp][Clnt]-512. Verbindung ist nicht für [] festgelegt. Mögliche Ursache: Die Eigenschaftswerte von Connection und ConnectionName sind beide leer
(english: Connection is not set for []. Possible cause: The property values of Connection and ConnectionName are both empty)
2.
Fehler in der Datenbankverbindung
[FireDAC][Phys][MySQL] Host 'DESKTOP-AP29UM' (the windows 10 client) is not allowed to connect to this MySQL server
(english: Database connection error. Host 'DESKTOP-AP29UM' (the windows 10 client) is not allowed to connect to this MySQL server)
The connection is with the IP of the server, port 3306, user 'root', no password. In my code I never set the sql_mode or any ConnectionName.
I have no clue why this all of a sudden happens. Can anybody point me in the right direction?
Subject
Written By
Posted
Connect to MySQL failed
May 04, 2023 04:58AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.