host is not allowed to connect to this mysql server

Reading Time: < 1 minute

1.the root user has not grand rights

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;

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

2.you can change the binding address

in linux (redhat variants)

nano /etc/my.cnf

and add this following line

bind-address = *

then restart mysql server

service mysql restart