Although working directly with the MySQL monitor allows you to the most control over what happens whilst also giving you the fastest and easiest feedback, it is true to say that many people find it daunting to use on a long-term basis. I encourage everyone to become comfortable within the monitor program when learning, but if you would rather stay clear of the command-line if possible, there is another solution just for you.

Designed to allow manipulation of MySQL databases and tables through a GUI, phpMyAdmin is itself written entirely in PHP. As such, you can administer your system over the web, either locally from the server or remotely from your own machine or indeed anywhere in the world.

It is currently available in over 47 languages, so there's almost certainly a version you can use in your own system. It can be downloaded from, and is available for free under the GPL licence. If you're using Linux and all you have in your package manager is an old version, it's still worth having - any version of phpMyAdmin is better than nothing!


Want to learn PHP 7?

Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!

If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!

Next chapter: PEAR::DB >>

Previous chapter: Unbuffered queries for large data sets: MYSQLI_USE_RESULT

Jump to:


Home: Table of Contents

Copyright ©2015 Paul Hudson. Follow me: @twostraws.