phpMyAdmin

phpMyAdmin (GUI, web browser interface)

phpMyAdmin is probably best known for being the MySQL client that is included in the Control Panel (such as cPanel) for customers at many shared web hosting companies. If you want to view the data in your installation of WordPress, SMF, phpBB, etc., phpMyAdmin might be your only easy-to-use option other than connecting directly to your website's MySQL server from your local PC, which your hosting account might not be configured to allow.

I haven't used phpMyAdmin much, and don't have a lot to say about it, but mention it here for the opportunity to point out that it is basically a MySQL client like the others described here except that it's written in PHP, you access it using your web browser, and it connects to your database using PHP methods, as described below.

In order to use phpMyAdmin on your PC, it is necessary to also install a web server such as Apache, and the PHP language interpreter.

When you install phpMyAdmin on your local PC, the "control user" that you must create, contrary to what its name implies, is actually a very low-privileged MySQL user whose only purpose is for phpMyAdmin to do its own administrative tasks. You normally do not give the control user privileges to access databases other than the one or two it requires for its own use.

To work with your databases from phpMyAdmin, log in as one of your other MySQL users that has privileges for the database you'll be accessing.