Connecting to mySQL from 2 different machines
So what you can do :


If you want to change IP from 192.168.1.4 to 192.168.1.3 then you can update mysql.user table 


Update mysql.user  set host =' 192.168.1.3 where host='192.168.1.3' ;

Flush privileges:

You cannot define a range of hostname in single query of creating user. Either you need to create same user for different IP or you can give % as hostname but i will not recommend this


If you want different user , create same user with required IP.


Let me know if need more clarity

EDIT

You cannot define a range for hostname in mysql.user table.
To have this you can create same user with same role but on different IP. You have to do this for every IP individually.

UPDATE

Please try creating user :

grant select to 'root'@'192.168.1.%' on db.* Identified by 'pass' ; 

UPDATE 2

This is because IP should be placed between '' as a string.

So here you go:

GRANT ALL PRIVILEGES ON db_name.table_name TO 'root'@'192.168.1.%' IDENTIFIED BY '' WITH GRANT OPTION;