host gateway is not allawed mysql code example
Example 1: host 127.0 0.1 is not allowed to connect to this mysql server
UPDATE mysql.user SET host='%' WHERE user='root';
Example 2: host not allowed to connect to this mysql server
mysql -u root -p
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;