/SQL/Host '192.168.43.100' is not allowed to connect to this MySQL server

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;

Source: stackoverflow.com

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

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

Source: stackoverflow.com

Similar codes

3 votes185 views1 answer
Mssql remove column
SQL
0 vote175 views1 answer
Mysql multiple count
SQL
13 votes194 views4 answers
What is sql
SQL
51 votes286 views6 answers
Change column name sql
SQL
5 votes187 views2 answers
Oracle tables with column name
SQL
3 votes183 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote190 views1 answer
OFFSET consulta mysql
SQL
0 vote186 views1 answer
Mod function example
SQL
4 votes182 views2 answers
Sql vs mysql
SQL
2 votes175 views2 answers
Join update query in sql
SQL