How to connect to remote DB in local phpMyAdmin (WAMP)?

mysql phpmyadmin remote-access local-database remote-connection
delux picture delux · Oct 22, 2015 · Viewed 11.1k times · Source

I'm using WAMP server with MySQL Version : 5.6.17. Is there a way to connect to remote DB from my local phpMyAdmin?

I have credentials for remote database, but I can not find a way how to add a connection in my local panel.

I found over the new that it is something related to some config file, or something called PMA, but couldn't found more details about it.

Answer

Kelvin Lai picture Kelvin Lai · Oct 22, 2015

In config.inc.php under your phpMyAdmin folder, change the value of $cfg['Servers'][$i]['host'] from 'localhost' to the ip address of your remote DB.

See http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_host for details.

Related questions

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
Setting up foreign keys in phpMyAdmin?

I'm setting up a database using phpMyAdmin. I have two tables (foo and bar), indexed on their primary keys. I am trying to create a relational table (foo_bar) between them, using their primary keys as foreign keys. I created …

Read More