Answers for "[HY000][1130] null, message from server: "Host '172.18.0.1' is not allowed to connect to this MySQL server"."

SQL
3

Host '192.168.43.100' 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;
Posted by: Guest on August-21-2020

Code answers related to "[HY000][1130] null, message from server: "Host '172.18.0.1' is not allowed to connect to this MySQL server"."

Code answers related to "SQL"

Browse Popular Code Answers by Language