/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 vote81 views1 answer
How to get last client id sql
SQL
1 vote128 views2 answers
Sql left characters
SQL
12 votes125 views2 answers
Delete entries in postgresql
SQL
13 votes84 views2 answers
Oracle all source
SQL
0 vote122 views1 answer
How to get n result in sql
SQL
12 votes131 views1 answer
Script to add new column in table sql
SQL
0 vote135 views2 answers
Return the number of records in a single table mysql
SQL
0 vote133 views1 answer
Get the First and Last Word from a String or Sentence
SQL
8 votes143 views1 answer
Database backup in mysql server recovery
SQL
1 vote119 views1 answer
Sql dcl
SQL