/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 vote118 views1 answer
Hangfire clean script
SQL
0 vote138 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote149 views2 answers
Sql use not in
SQL
0 vote149 views1 answer
Sql select most frequent value in column
SQL
0 vote138 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
8 votes174 views4 answers
Reset SQL auto increment
SQL
0 vote144 views1 answer
Drop constraint in ms sql
SQL
1 vote163 views1 answer
Mysql strict_trans_tables
SQL
3 votes145 views3 answers
Sql last week
SQL
7 votes181 views3 answers
Restore postgres database from sql file
SQL