/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 vote201 views1 answer
Mysql f# examples
SQL
1 vote197 views1 answer
Oracle list constraints
SQL
11 votes239 views3 answers
Change column name sql server management studio
SQL
1 vote236 views3 answers
Default password of mysql
SQL
0 vote198 views1 answer
Sql change default collation to utf8
SQL
0 vote223 views1 answer
Oracle step procedure
SQL
0 vote200 views1 answer
Date on SQL
SQL
0 vote194 views1 answer
Tsql default value when no value returned by query
SQL
15 votes304 views4 answers
Mysql export database command line
SQL
0 vote226 views1 answer
Database db connection string format
SQL