PHPMyAdmin vs. (windows equivalent of) sequel pro recommendation

September 8, 2015 1.1k views

At the beginning of this video users are strongly recommended to use sequel pro instead of PHPMyAdmin, due to PHPMA making some information publicly available when it's likely that you won't want it to be. However, this video series seems to entirely revolve around the use of PHPMA. Since I'll be following along with both video series to the best of my ability and do not want users of the end product to be able to view confidential information, which program should I use? Problems include:

  • If I use PHPMA, users will be able to view confidential information, which is unacceptable. As such, the videos' creator strongly recommends that we don't use it.
  • If I use a windows equivalent of sequel pro instead of PHPMA, there's a strong possibility that I won't be able to follow the 2nd video series at all since their layouts - and possibly what they're capable of doing, too - won't match up at all. It's likely that I'll be asked to do something in a video which isn't possible to do with the program I end up using.
  • Since I'm a complete novice to PHP, MYSQL, and software that's designed to make working with them easier and more efficient, I don't know which windows equivalent of sequel pro I should use, if any. Whatever it is, it must have the capability to follow along with the 2nd video series.
1 comment
  • Sorry, I linked the wrong video, though the one I linked also strongly recommends against using PHPMA.
    "And there are important security considerations when you [upload] any software like PHPMA to your server, because obviously it will then be publicly available, so anyone can go ahead and access it." (It then mentioned password protection, but both before and after this, and in other videos, the speaker strongly recommended against using PHPMA due to this security vulnerability, so I'm not sure how secure this is.)

3 Answers

What "confidential information" can users view when you use phpMyAdmin?

I have no idea, as I am a novice who knows nothing about PHPMA. I'm paraphrasing what was stated early on in the first video that was linked.

Have another answer? Share your knowledge.