Monday, 21/5/2018 | 8:37 UTC+5
Mehta Websolution's Blog

MULTIPLE MYSQL SERVERS FROM ONE PHPMYADMIN INSTANCE

Post by relatedRelated post

At some point in your development career, it is likely that you will want to work on multiple MySQL servers. Personally, I like using phpMyAdmin for quick database management. However, what I don’t want to do is maintain multiple instances of phpMyAdmin. I also don’t want to install phpMyAdmin on any production web-servers.

What I would much rather do is install a local instance on my development machine, make sure it isn’t accessible to the outside world, and let it manipulate my local (test/development) environment and on occasion my production environments. Luckily, phpMyAdmin allows you to do just that.

To set this up you will want to navigate to the installation directory of phpMyAdmin (Mine is in C:\wamp\apps\phpMyAdmin-4.0.4.1) and check to see if you have a file named config.inc.php floating around in there. Follow the next steps based on whether that file exists:

If File doesn’t exist:

    • Create a file config.inc.php
    • Add the following updating for your server’s connection data and increment $i for each subsequent server added:
    • Save the file
    • Navigate to your phpMyAdmin instance using a browser
    • On the left-hand navigation pane you will now see a drop-down near the top preceded by the words “Current Server:”
    • When you change this your phpMyAdmin instance will reload itself with the new server in scope

If File does exist:

  • Open the file config.inc.php in your favorite editor
  • Make sure your file has the following code in it:
  • After this code add the following updating for your server’s connection data and increment $i for each subsequent server added:
  • Save the file
  • Navigate to your phpMyAdmin instance using a browser
  • On the left-hand navigation pane you will now see a drop-down near the top preceded by the words “Current Server:”
  • When you change this your phpMyAdmin instance will reload itself with the new server in scope
About

Mehta Websolution is a web development company based in Jamnagar, Gujarat, India. providing a full range of web services including web design, web development, web promotion, search engine optimization, web hosting and domain registration and all Internet services at accessible cost since it was established in 2007. A company which provides you a full range of web services Contact us for web design, web development, web promotion, search engine optimization, web hosting and domain registration at an affordable cost. IF you are looking for an IT Solutions Provider who can implement your Dreams in a reality form of exhaustive web applications, innovative software, and creative designs or for fastidious solutions and persistent services, you are at the right place. we provide you software development and web solutions all across the globe. Our strategic location and proven experience enables us to provide you with the best services and outsourcing for your Software Development, Web Development, E-commerce, Multimedia Presentations and Web Based Applications at the corporate level.

POST YOUR COMMENTS

Your email address will not be published. Required fields are marked *

twelve − five =

Mehta Websolution Since 2007

Company is Government & Defence (Indian Navy, Army & Air Force) Approval I.T. Contractor, An ISO 9001:2008 Certified I.T. Company and Google Enterprise for Work Partner.