Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 config.inc.php 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
1  
This should be on serverfault. Make sure that the remote database allows remote connetions at all. –  Michael-O Jul 27 '11 at 5:53
1  
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
1  
@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
show 2 more comments

migrated from stackoverflow.com Jul 27 '11 at 22:40

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

3 Answers

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
add comment

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

see the phpmyadmin wiki page: http://wiki.phpmyadmin.ne/pma/Config#Server.28s.29_configuration

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

Thanks!

share|improve this answer
add comment
up vote 0 down vote accepted

If anyone else needs / wants to know I used SQLyog

share|improve this answer
add comment

Your Answer

 
discard

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.