Since we installed the latest upgrade for Sage 50 to Version 2018.0, we are unable to connect to the simply database with our third party software using a ODBC Connection.
Over the past 10 years I have always managed to make the appropriate adjustments as Sage software was updated but this one has me stumped.
On the advise of tech support, I have installed MySQL Server 5.7.18 and ODBC Connector 5.3.7 which is the version levels that Sage 50 uses.
The server start as a windows service "MySQL57" successfully, however fails when I attempt to connect using the ODBC Connector:
Connection Failed
[MYSQL] [ODBC 5.3(a) Driver] Access denied for user 'root'@' localhost' (using password: YES);