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