/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

9 votes117 views4 answers
How to create new user and database postgresql in ubuntu
SQL
2 votes123 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote126 views1 answer
Mysql get date diff in months
SQL
0 vote121 views1 answer
SQL add a totals of differemt rows of the same id
SQL
14 votes120 views4 answers
Sql compiler
SQL
1 vote111 views1 answer
Pv mysql import
SQL
1 vote124 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
2 votes143 views1 answer
Find column in all stored procedures sql server
SQL
0 vote126 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote116 views1 answer
Sql column as header
SQL