sqlMessage is not allowed to connect to this MySQL server" 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 is not allowed to connect to this mysql server
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;