/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

1 vote159 views1 answer
Mysql batch insert
SQL
0 vote175 views1 answer
Flexible search query delete table
SQL
0 vote197 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote161 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote183 views1 answer
Sql bild in function
SQL
0 vote132 views2 answers
Postgresql could not start server mac
SQL
1 vote195 views1 answer
Join to find results not in another table
SQL
0 vote166 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote185 views1 answer
Sql revert migration
SQL
0 vote185 views1 answer
Distance calculator from lat long sql query
SQL