/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

0 vote134 views1 answer
How to reset AI in sql
SQL
0 vote135 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote143 views1 answer
Sql datediff month
SQL
0 vote147 views1 answer
How to use lower case in mysql
SQL
0 vote149 views1 answer
Count characters of string mysql
SQL
0 vote144 views1 answer
Sqlite referential integrity
SQL
0 vote136 views1 answer
Mysql change default collation
SQL
1 vote105 views2 answers
Procedure pl/sql
SQL
1 vote138 views1 answer
Restart identity postgresql
SQL
1 vote149 views2 answers
Begin transaction sql
SQL