/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 vote176 views1 answer
Reset postgres table index to next max value
SQL
1 vote204 views1 answer
Oracle previous year
SQL
2 votes146 views1 answer
Plsql block
SQL
5 votes182 views1 answer
Purge undo tablespace usage
SQL
21 votes122 views7 answers
Table drop if exist sql server
SQL
0 vote182 views1 answer
Sqlalchemy empty table
SQL
0 vote184 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote206 views1 answer
SQL Server Enterprise
SQL
5 votes145 views2 answers
Oracle to_timestamp
SQL
0 vote196 views3 answers
CONTACT FORM SQL
SQL