How to connect remote DB from localhost using PhpMyAdmin

Connecting to a remote database from localhost can be done in many ways. Here I am going to explain a very simple way to do so. That is, connecting a remote database using phpmyadmin in the local server.
To do so you need to follow the simple steps given below,
Note: Hope you guys have server installed in your local machine Xampp, Wamp etc. I am using xampp for the tutorial.

1.       Open the XAMPP control panel. You can open it from the Xampp directory. (eg: C:\xampp ->xampp-control)
2.       Click on the Config button on the right side of Apache and select PhpMyAdmin (config.inc) from the dropdown list.
3.       Now you need to add the connection details in the config.inc document just before the php closing tag in the following format.
Eg:
$i++;
$cfg['Servers'][$i]['host'] = ''; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = '';//user name for your remote server
$cfg['Servers'][$i]['password'] = '';//password
$cfg['Servers'][$i]['auth_type'] = 'config';
4.       Now save the document and restart the server.
5.       Open phpmyadmin (localhost/phpmyadmin/) and you can see a section on the left sidebar “Current server:” with a dropdown list. From the list you can select the remote server and do the work.
Hope this tutorial is helpful to somebody. You can give your feedback on the comments below.

14 comments:

  1. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    Cyber Security Projects for Final Year

    JavaScript Training in Chennai

    Project Centers in Chennai

    JavaScript Training in Chennai

    ReplyDelete
  2. In this current economic environment, no one can afford to put their career on the back burner. With so many layoffs in the last couple of years, task list templates

    ReplyDelete
  3. Hi buddies, it is great written piece entirely defined, continue the good work constantly. UK RDP

    ReplyDelete
  4. Wonderful content as always. I love how you talk about the projects and topics in detail. Keep the articles coming.

    ReplyDelete
  5. This information was very helpfull for all.thanks for sharing these information with all of us. Kinemaster Gold

    ReplyDelete
  6. Incredible post I should say and a debt of gratitude is in order for the data. Schooling is certainly a tacky subject. Be that as it may, is still among the main subjects within recent memory. I appreciate your post and anticipate more. You have made some valid statements there. I looked on the web to study the issue and discovered a great many people will oblige your perspectives on this site...
    how to make a paper airplane eagle | how to make a boomerang airplane | the eagle paper airplane | best paper airplane design for distance and accuracy | best paper airplanes for distance and speed | what is the best paper airplane design for distance | paper airplane that flies far and straight | nakamura lock paper airplane instructions | paper airplane templates for distance | science behind paper airplanes

    ReplyDelete
  7. I want to give you a big thumbs up for this nice work. Thanks for this fantastic post. Keep updating your more ideas with us.

    ReplyDelete
  8. Thanks for getting me back into reading again. I really enjoyed the stuff you shared in the form of blogs. Keep writing.

    ReplyDelete