Answers for "1130: host '127.0.0.1' is not allowed to connect to this mysql serve"

host 127.0 0.1 is not allowed to connect to this mysql server

UPDATE mysql.user SET host='%' WHERE user='root';

Posted by: Guest on January-22-2021

Host '' is not allowed to connect to this MySQL server

GRANT ALL PRIVILEGES ON *.* TO root@my_ip IDENTIFIED BY ‘root_password‘ WITH GRANT OPTION;

Posted by: Guest on July-26-2021

Code answers related to "1130: host '127.0.0.1' is not allowed to connect to this mysql serve"