Friday, October 24, 2014


Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server


Solution :

To solve this issue, you  need to give access permission to the user.

Below queries can be used to give permission to the 'dbuser'


GRANT ALL PRIVILEGES ON schema_name.* TO 'dbuser'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;


After executing the queries , dbuser can access the database from a remote machine.