/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

19 votes287 views2 answers
Mysql tinyint max value
SQL
0 vote282 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote282 views1 answer
Window function to forward fill
SQL
3 votes296 views1 answer
Oracle transaction commit rollback example
SQL
0 vote270 views1 answer
Get last updated row sql server
SQL
1 vote276 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote285 views1 answer
Sql query to find duplicate email address
SQL
0 vote262 views1 answer
Default column value in sql same as other column
SQL
0 vote268 views1 answer
Mysql update privileges
SQL
6 votes300 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL