Question: odbc connection failed host is not allowed to connect to this mysql server?
Answer: This error occurs due to the default configuration your MySQL database is currently using. This configuration allows connections only from the 'root' user when coming from 'localhost' and not other IP address ranges.