/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

1 vote192 views1 answer
How to drop function in sql
SQL
0 vote210 views1 answer
How to get nth number in sql
SQL
2 votes200 views2 answers
Postgresql search all tables for column name
SQL
0 vote200 views1 answer
Mysql pad zeros
SQL
-1 vote216 views3 answers
Compute age mysql
SQL
0 vote193 views1 answer
T sql return on letters only
SQL
1 vote220 views1 answer
Oracle list data files
SQL
2 votes211 views1 answer
Query to find table size in oracle 12c
SQL
0 vote208 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
5 votes196 views1 answer
Sort order on two columns sql
SQL