/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 vote353 views1 answer
How to check the port of mysql installation in mac
SQL
4 votes356 views1 answer
Search column by name mysql
SQL
1 vote372 views1 answer
Oracle enable job
SQL
4 votes351 views2 answers
Oracle last day of month
SQL
0 vote360 views1 answer
Run mysql xampp shell
SQL
0 vote350 views1 answer
Dump db only triggers mysql
SQL
0 vote399 views1 answer
What is delimiter in mysql
SQL
58 votes603 views4 answers
Mysql drop column
SQL
0 vote336 views1 answer
Raiserror nowait sql server
SQL
0 vote370 views3 answers
Postgres date difference seconds
SQL