Mysql: is not allowed to connect to this MySQL serverCsed by foreign host.


If you try to connect from a remote machine to a particular db and get the following:
is not allowed to connect to this MySQL serverCsed by foreign host. (connect, as in telnet 3306)

Need to set permissions, after logging onto mysql prompt as root:
mysql -u root (supply password, if any)
GRANT ALL PRIVILEGES ON database.* TO user@’%’;
GRANT ALL PRIVILEGES ON database.* TO user@’localhost’;

Leave a Comment