How to add remote DB in phpmyadmin
#phpmyadmin #mysql

How to add remote DB in phpmyadmin

Table Of Content


  1. Step 1: Updating the configuration
  2. Step 2: Copy and Paste

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

Most Viewed Posts


Must Read


January 28, 2022

#AppImage #linux

How to Add AppImage Application to Menu in Ubuntu (Linux)

AppImages are the most easiest to run compared.The challenging task is to make the AppImage accessible globally through he system like an installed application (in the menu)

Reading time: less than a minute
How to Add Laravel Pint to VS Code Formatter
June 24, 2022

#code-quality #vscode #laravel-pint #laravel

How to Add Laravel Pint to VS Code Formatter

I have been using the unsatisfactory formatters from a long time. All of them have one thing but lack other. Laravel Pint is one who has it all, combining it with vscode is like proving you laravel project a super power.

Reading time: 2 minutes
March 24, 2021

#express js #node #node js #sequelize #mysql

How to create model association in Sequelize - express JS / Node JS

In the very initial days of my work in Node JS if faced this issue. Though Sequelize provide a great ORM for MySQL but the association within the models is a bit tricky.

Reading time: 2 minutes
December 14, 2021

#database #javascript #sequelize #npx

Sequelize CLI Commands

list of Sequelize CLI commands which comes handy, while working on a project.

Reading time: 1 minute
How to create a progressive web app (PWA) in laravel 5.* and above
July 07, 2019

#functionality #pwa #javascript #laravel

How to create a progressive web app (PWA) in laravel 5.* and above

The progressive web app is the new trend as well as the need for the present time. I hope before getting in the “HOW” part you know what is exactly a PWA

Reading time: 4 minutes
March 24, 2021

#express js #node #node js #sequelize #mysql

How to create model association in Sequelize - express JS / Node JS

In the very initial days of my work in Node JS if faced this issue. Though Sequelize provide a great ORM for MySQL but the association within the models is a bit tricky.

Reading time: 2 minutes
August 15, 2019

#cli #mysql

How to take MySQL DB back up from the command line

As you know regular backups of DB for a running site are very important. Most of the hosting providers do this for you, but sometimes its also expected from you to do the same.

Reading time: less than a minute
November 15, 2018

#sql injection #php #mysql #security

How to Sanitize Input in PHP

The inputs in Core PHP are venerable to what you call “SQL Injection”, to before putting them to use it’s a mandatory practice to sanitize them

Reading time: 1 minute
May 25, 2019

#cli #mysql

Command to import DB through the command line in MySQL

Reading time: less than a minute
mohammed-samgan-khan

Hi, I am Samgan, I know the adds are bit annoying but i hope you understand. Talking about me, I excel at solving complex problems involving logic and step by step breakdown of the problem. Besides, to develop complex algorithms, I specialize in problem framing, systems design, and product development strategy. Sometimes I also enjoy public speaking.