/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 vote235 views1 answer
Mysql enter ubuntu
SQL
0 vote231 views1 answer
Zerar auto increment mysql
SQL
0 vote215 views1 answer
Left join in codeigniter query builder
SQL
3 votes192 views1 answer
Postgresql where current year
SQL
17 votes294 views4 answers
Show all tables in oracle
SQL
0 vote233 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
6 votes234 views1 answer
Oracle list primary key
SQL
0 vote220 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote221 views1 answer
Mod in sql
SQL
0 vote237 views1 answer
Run mysql xampp shell
SQL