“Mastering phpMyAdmin 2.11 for Effective MySQL Management” by Marc Delisle
This book on phpMyAdmin is written by Marc Delisle, one of the core developers of the application which I think just about any software developer utilising MySQL has dabbled with at the least. I can honestly say that anyone that experimented with phpMyAdmin before reading this book will use it much more thoroughly and more productively afterwards.
This is a well written, easily read, book that is fully comprehensive regarding how to use phpMyAdmin for both casually inserting and maintaining data in a mysql database; checking queries before utilising them in your code; data transformations; and actual database and user administration, such as changing the structure of your databases, collations, creating system documentation, assigning privileges and more.
I scarcely believe this book could be much more detailed, especially as it often has more than two screen shots per page – it is no wonder that I now know much more of what phpMyAdmin is capable of!
The troubleshooting chapter at the back seems invaluable and the chapter covering MySQL 5 additions seems a useful refresher for those of us that may need to be reminded of new functionality present only in that more recent version of MySQL, and after reading this book I fully expect that I shall be using phpmyadmin more and not using either the MySQL Query Browser or Oracle’s SQL Developer as much.
The blurb on the back of the book says that it is for every serious phpMyAdmin user who would like to use this outstanding application to its full power – after reading it I am very much inclined to agree and would recommend it to anyone that uses phpMyAdmin on a daily basis.