Xampp is installed and running. However, I wish to create an ODBC connection from my workstation to the MSsql database. Downloaded 3.51 of the MySql ODBC driver and specifying the following:
Server: 192.168.117.54
user: root
password:

when I try to select the database I get the error: "request returned with SQL_ERROR.

Click on diag and get the following: [MySQL][ODBC 3.51 Driver]Host 'c-0115.companydomain.subcompanydomain.com' is not allowed to connect to this MySQL server

Thank you. Have I mentioned I'm a newbie idiot? I created the user originally straight in the user table. I now found the Privilige form, which allows me to add a new user, and sure enough, spelled out clearly is the option to make the user avail from any host.