Fix Error : "Host 'xx.xx.xx.xx' is not allow to connect to this MySQL server"

             When you install MySQL Database on PC. You can connect to MySQL Database by root in hostname localhost or 127.0.0.1 only. You cannot connect by other device by IP Address. If will show error  "Host 'xx.xx.xx.xx' is not allow to connect to this MySQL server" . So you will config your MySQL to allow other device to connect it follow instruction below.


1. If your PC installed XAMMP. Open command line and goto that directory. 

 2. Type below. 

mysql -u root -p                                                                                

Enter password and Enter.

3. Type below.

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

4. Type below.

FLUSH PRIVILEGES; 

6. Finished.