/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

2 votes324 views1 answer
Oracle list grants on package
SQL
0 vote323 views1 answer
Database get 10 user aleatory
SQL
0 vote367 views1 answer
Consecutive numbers sql
SQL
0 vote338 views1 answer
Mysql error 1251
SQL
0 vote356 views1 answer
Mql5 datetime get hour
SQL
0 vote331 views1 answer
Get who is hired in month in sql
SQL
0 vote328 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
7 votes346 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
1 vote335 views2 answers
Pad zero sql server
SQL
6 votes328 views2 answers
Sql query to get the number of rows in a table
SQL