/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 vote207 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote206 views1 answer
Sql select sum group by id laravel join
SQL
4 votes229 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote219 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote196 views1 answer
Update view sql
SQL
0 vote189 views1 answer
Sqlite commands
SQL
-1 vote183 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
-1 vote222 views2 answers
Sql search all tables for attributes
SQL
0 vote202 views2 answers
How to see table associated with a schema in sql
SQL
10 votes185 views1 answer
Dba_dependencies
SQL