/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

13 votes364 views2 answers
Sql count distinct group by
SQL
1 vote344 views1 answer
Oracle stop job
SQL
0 vote458 views1 answer
Mysql get nested records
SQL
0 vote368 views1 answer
To Create directory
SQL
2 votes374 views1 answer
How to create sql database
SQL
0 vote318 views1 answer
Java spring boot connect to sql server
SQL
0 vote380 views1 answer
Renombrar tabla mysql
SQL
0 vote348 views1 answer
Get last updated row sql server
SQL
3 votes361 views2 answers
Monthname sql
SQL
37 votes367 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL