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

Leave a Reply

Your email address will not be published. Required fields are marked *