#phpmyadmin #mysql

How to add remote DB in phpmyadmin

There are a number of MySQL client but so far phpmyadmin is one of the popular MySQL client used. It’s simple to use, effective and provide almost all the required features for day to day development.

Connecting to remote is something you don’t need so often but when you need it, I can bet it’s a critical situation. Here below we will discuss 2 simple steps to add a remote connection to your phpmyadmin.

Step 1: Updating the configuration

Open your phpmyadmin installation, if you are using XAMPP, you will find it the XAMPP installation directory. Once you are in the phpmyadmin installation, open “config.inc.php”

Step 2: Copy and Paste

In this file, you will find the configuration for the localhost, copy and paste the same with the remote details.

And we are done.

Now you will be able to see remote details in the drop-down

mohammed-samgan-khan

Hi, I am Samgan, I excel at solving complex problems involving logic and step by step breakdown of the problem. Besides, to develop complex algorithms, I specialise in problem framing, systems design, and product development strategy. Sometimes I also enjoy public speaking.  

I am also the creator of penit.ink, a site which provides young writers with a free hand place to show their creation to the world. Irrespective of the niche, if you write this place is defiantly for you.