In the first segment of this two-part tutorial, I gave you a quick overview of some of the interesting new features available in phpMyAdmin. In this concluding segment, find out how to use phpMyAdmin to define relationships between tables, maintain a log of commonly-used queries and create entity-relationship diagrams.
In the first segment of this two-part tutorial, I gave you a quick overview of some of the interesting new features available in phpMyAdmin. Starting with the basics of the installation process and proceeding to the intricacies of securing your instance of phpMyAdmin from prying eyes, changing the application's appearance and using its built-in reporting features to obtain information on who is using your MySQL RDBMS for what, I hope you're slowly realizing the utility of this wonderful open-source tool. In fact, I'm going to stick my head out and state that in my humble opinion, phpMyAdmin is to a MySQL developer what TOAD is to an Oracle developer.
You might disagree with this - after all, TOAD allows developers to model a database schema, perform step-by-step SQL debugging and a whole lot more. In fact, that's the reason I came back for part two - to convince skeptics such as yourself that phpMyAdmin is indeed a worthy competitor, having added many useful features over the years.