Allow MySQL Access in LAN

If you want to access MySQL database in LAN (Local Area Network) in which computer's IP is in pattern '192.168.0.*',

Just run the below command in MySQL

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.%'
    IDENTIFIED BY 'root'  
    WITH GRANT OPTION;
FLUSH PRIVILEGES;