Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

it return error can't connect to (ip of server) Error Host is now allowed

how to fixed this ?

system running on VM CentOS 6, when use phpmyadmin are work well but not work with MySQL GUI Administrator Tool

here is my iptables

# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 80 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 443 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 10000 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 10082 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited

enter image description here

share|improve this question
up vote 3 down vote accepted

If you have your MySQL server listening on all interfaces/public interface then the problem is likely with your user table. There is a 'host' value that defines which hosts are permitted to access the MySQL server (which you can change from the phpMyAdmin Privileges tab). Your host value doesn't match the one you are trying to connect from (i.e. the host value might be 'localhost', a common value, and you are not connecting from 'localhost'). I believe it is also possible to setup a separate Hosts table for more complex permissions.


share|improve this answer
thank you cyberx86 – RAGOpoR Jul 15 '11 at 5:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.