Cannot connect to remote MySQL database. Resolution.

Download and install MySQL Administrator.

MySQL Administator

 


  • Login to MySQL Administrator
  • Goto User Administration and right click on user (ie root)
    User Administration
  • From drop down menu select “Add host from which the user can connect
    Drop Down Menu
  • From the popup box, type %
    PopUp Box
  • Save
  • Done

The Final Result:
Original Setting:
Original Default Setting
Modified Setting:
Modified Setting