/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 vote121 views1 answer
How to retrive the today date sql
SQL
14 votes112 views2 answers
Oracle export trigger ddl
SQL
0 vote126 views1 answer
Synapse sql table set pk
SQL
3 votes144 views1 answer
Oracle nextval insert
SQL
0 vote106 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
45 votes179 views5 answers
Grant all privileges mysql
SQL
0 vote103 views1 answer
Oracle job class
SQL
2 votes113 views1 answer
Mariadb select multiple rows into one column
SQL
4 votes104 views2 answers
Convert utc to est sql
SQL
0 vote132 views1 answer
Sp help text in postgresql
SQL