/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

2 votes203 views1 answer
Laravel sql String
SQL
0 vote230 views1 answer
Sql constarint
SQL
0 vote198 views1 answer
Run postgresql dump to csv
SQL
0 vote222 views3 answers
Delete in SQL SERVER
SQL
0 vote185 views1 answer
Ms Sql set us timezone
SQL
0 vote217 views1 answer
Exclude last comma separated string mysql
SQL
0 vote184 views1 answer
Lister les index d'une table oracle
SQL
0 vote191 views1 answer
How to access to mysql without root
SQL
1 vote210 views1 answer
Psql autocomplete for mac brew install
SQL
11 votes212 views1 answer
Ddl materialized view
SQL