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.

7 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