/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

3 votes506 views6 answers
Sql unique select
SQL
7 votes343 views2 answers
MySQL IF without else
SQL
4 votes297 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
2 votes286 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote315 views1 answer
How to output a different column name in mysql
SQL
1 vote306 views1 answer
Real world example of nosql
SQL
1 vote312 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote356 views1 answer
Add user mysql wordpress
SQL
5 votes329 views2 answers
Sql number columns
SQL
7 votes323 views3 answers
Sql fill table with info from anothe rtable
SQL