Engine23
blogBannerImage
By Engine23

Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server

mysql> CREATE USER 'edreamery_prod'@'localhost' IDENTIFIED BY 'edreamery_prod'; Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'edreamery_prod'@'localhost' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec) mysql> CREATE USER 'edreamery_prod'@'%' IDENTIFIED BY 'edreamery_prod';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'edreamery_prod'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)