SQL error (1130): Host IP is not allowed to connect to this MySQL Server

SQL Error (1130): Host '192. 168.1.100 'is not allowed to connect to this MySQL
Server

This indicates that the connected user account does not have the permission for remote connection and can only log on to the Local Machine (localhost.

Mysql needs to be changedDatabaseHost entry in the user table
Rename localhost as %

First, log on to the Mysql server by following the steps below

To log on to mysql, you need to switch to the bin directory of mysql under dos and perform the following operations:

Mysql> use mysql;

Mysql> update user set host = '%' where user = 'root ';

Mysql> flush privileges;

Mysql> select 'host', 'user' from user where user = 'root ';

Mysql> quit

OK. Remote connection successful!