Check the user root has rights to connect to localhost from your address (MySQL rights define what clients can connect to the server and from which machines). Make sure you are both providing a ...

null, message from server: "Host '127.0.0.1' is not allowed to connect to this MySQL server" wonder how does this host is changed from localhost to ip address 127.0.0.1 but when connect to remote ...

The connection working well in localhost but after publishing the app to IIS it gives the exception below. MySqlException: Unable to connect to any of the specified MySQL hosts.