/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 vote139 views1 answer
Oracle gather table statistics
SQL
0 vote147 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote152 views1 answer
Changing name of column and datatype in sql
SQL
8 votes160 views1 answer
Oracle add datafile to tablespace
SQL
16 votes153 views3 answers
Jwt secret key generator laravel
SQL
1 vote157 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote161 views2 answers
Amazon linux postgresql client
SQL
0 vote151 views1 answer
Sql value exists in column
SQL
0 vote135 views1 answer
Order by ip address sql
SQL
0 vote205 views1 answer
TSQL Find csv file in folder
SQL