I am using MySQL ODBC 3.51.21 32 bit on Windows 2012 Server 64 bit. I am connecting to a MySQL database engine 5.7 x64.
As this is in a virtual environment all of the 2012 systems are the same.
On some machines when I create the ODBC connection it will accept 'root' as the user. On others it insists on 'email@example.com'. This is very difficult as I do not want to set up each computer with it's own user.
Does anyone have a solution as to why some machines want the full machine name in the login?