/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 vote140 views1 answer
Nvl2 syntax
SQL
0 vote229 views1 answer
Oracle sql alter view add column
SQL
0 vote215 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote158 views1 answer
Authentication modes in sql server
SQL
9 votes134 views2 answers
Sql server check table exists
SQL
0 vote143 views1 answer
Trigger vérifier stock
SQL
0 vote150 views1 answer
PGSQL dynamic table name
SQL
0 vote90 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote146 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
20 votes138 views6 answers
Change password in mysql
SQL