“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.
Thank you Ken for this kind review! Indeed we were generous on screenshots…
- the author.
hey guys,look what i have found sqlyog an amazing mysql db administartion tool offered under open source even free community version. Recommendable.
I’m new to PHP and recently setup my local machine with PHP and MySQL for doing development. I was sort of stuck when I needed to post my work for the user to test and review. After looking around a bit I found a site that hosts PHP and MySQL apps. I was surprised that it was free – it seems they’re offering the service at no cost until 2012. At that point they’ll change over to a fee-based service. However, in the meantime, it’s a great place to do anything from demo and sandbox right up to posting sites for real.
Their pitch is as follows:
“This is absolutely free, there is no catch. You get 350 MB of disk space and 100 GB bandwidth. They also have cPanel control panel which is amazing and easy to use website builder. Moreover, there is not any kind of advertising on your pages.”
Check it out using this link:
http://www.000webhost.com/83188.html
Important: There’s one catch in that you must make sure you visit the account every 14 days – otherwise the account is marked ‘Inactive’ and the files are deleted!!!
Thanks and good luck!
[...] Book review: “Mastering phpMyAdmin 2.11 for Effective MySQL Management” by Marc Delisle [...]