Search in This Blog

Set all remote host to mysql database


How to set all remote hosts to MySQL?

While you  are working with remote production MySQL database, you need each time to open phpMyAdmin. It is time taking and working with it execute sql queries very slow. So you need a tool that connect with your remote production MySQL database. for security reason hosting company not enable connect all remote IP to MySQL database server. you need to set it by one remote IP or all IP. For one remote IP simple put the IP address in the field indicated in below image on the other hand if you need to access remote MySQL database from all IP the put % sign in that field. See below how to it.


1) Open your control panel
2) Click on "Remote MySQL" link.
3) Put "%" in Host text box and click on "Add Host". see below image

Now you can connect your remote mysql database from any host.