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. 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
  2. Hi buddies, it is great written piece entirely defined, continue the good work constantly. UK RDP

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

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

    ReplyDelete
  5. 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
  6. Thanks for getting me back into reading again. I really enjoyed the stuff you shared in the form of blogs. Keep writing.

    ReplyDelete
  7. Cash Register Pro Crack is a reliable and trustworthy tool for selling products and registering inventory through PC. Cash Register Pro Crack

    ReplyDelete
  8. Adobe XD CC Keygen is the powerful new version is working through the drawing areas and the user work through one or many of work point it does not way of the problem can sure on the result. Adobe XD Cracked

    ReplyDelete
  9. Quotes to assist You Cope once Losing a husband those we tend to care regarding ne’er absolutely abandon U.S.A.. Loss Of A Husband Quotes

    ReplyDelete
  10. This content is simply exciting and creative. I have been deciding on a institutional move and this has helped me with one aspect. remote vibrator

    ReplyDelete
  11. Such a wonderful post.power bi training in kphb Thank you for sharing this post.

    ReplyDelete