Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

is there any way to manage a remote MySQL server using a local phpMyAdmin? I don't think they will allow me to upload a copy of phpmyadmin through ftp. For the meantime, I've been managing the remote db through CLI and it really is a pain. I tried changing the host value in of phpmyadmin. I think I am able to connect to the DB but it always says "No databases".

I am certain that I have entered the correct IP address of my MySQL host and I am entering the correct username and password. But why is it showing "No Databases"?

share|improve this question

migrated from Jul 27 '11 at 22:40

This question came from our site for professional and enthusiast programmers.

This should be on serverfault. Make sure that the remote database allows remote connetions at all. – Michael-O Jul 27 '11 at 5:53
As long as we're posting off-topic questions, how about an off-topic answer: Why is managing the DB through the CLI a pain? Most professional DBAs aren't installing phpMyAdmin... – Dan Grossman Jul 27 '11 at 5:56
@Dan Even though you say that most professional DBAs are using a CLI, believe it or not I would really prefer to use a GUI. I really want my rows to show with a little pretty formatting and I really find the feature of viewing content in one click really useful. Why would I settle for a CLI if there is a GUI alternative? I really am sorry if I am not at a level that you are expecting developers to be. – Rolando Cruz Jul 27 '11 at 6:04
@Michael-O I am able to connect to the DB through CLI and have been doing so to the present. Is the connection made by mysql different from what phpmyadmin is using? – Rolando Cruz Jul 27 '11 at 6:11
Well, if you are connecting locally, phpMyAdmin uses Unix Domain Sockets, probably mysql does too. Remote connection uses TCP. Try mysql from a remote host. – Michael-O Jul 27 '11 at 6:25

If you are actually logging in, but it says no databases, this is an issue you will have to take up with the hosting provider. It may be for security purposes that they do not allow exterior connections to the mysql databases.

share|improve this answer

Yes, you can do it easily via phpMyAdmin. Check this wiki:

see the phpmyadmin wiki page:

That should be enough. Let me know if you have any problem doing it.


share|improve this answer
up vote 0 down vote accepted

If anyone else needs / wants to know I used SQLyog

share|improve this answer

Just add below lines to your “” file in the bottom:

$cfg['Servers'][$i]['host'] = 'HostName:port'; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = 'userName';   //user name for your remote server
$cfg['Servers'][$i]['password'] = 'Password';  //password
$cfg['Servers'][$i]['auth_type'] = 'config';       // keep it as config

. You will get “Current Server:” drop down with both “” and one what you have provided with $cfg['Servers'][$i]['host'] cam switch between the servers.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.