20 MySQL Admin and Development Tools and cheat sheets

MySQL is a very feature rich relational database management system (RDBMS) which has more than 11 million active installations and 60,000+ downloads/day. MySQL is commonly known to be an open source project available for free under GNU General Public License – this version of MySQL is called Community Server. MySQL Community Server is very often used in a development stacks consisting of Apache with the popular mod_php module interpreting PHP code running on Linux (LAMP – Apache HTTP Server MySQL PHP). All very successful free open source projects that together serve millions of websites today and the number is growing rapidly. Popular open source systems like Wordpress, Joomla, Drupal, PHPbb and many more all run on this software stack.

MySQL is also offered in a version called Enterprise Server allowing companies to get Enterprise scale database software at a reasonable price (subscription based). See a comparison table here. The free community server is an excellent RDBMS but the tools you need as an DBA/Web site administrator or developer are only available if you subscribe to the Enterprise Server. Even though MySQL Enterspise Server is cheat compared to other high end database servers it is typically not an option for a blog or a small comapany website. Luckily there are other options and you can easily find free or cheap software providing the features you need.

If you’re using the MySQL Community Server or if you’re expecting to start using ityou need to find yourself some tools to support your management and development of your databases. As MySQL as open source roots there are many high quality 3rd party tools available and if you find the right match for yourself it may give significant advantages. It is always useful to know what tools you have available and what features they offer.

In the overview below tripwire magazine present some of the most useful and most popular MySQL Admin and Development Tools that both beginners and professionals can benefit of. Please drop a comment if an useful MySQL-tool is missing in the list and it will be added ASAP. [Detail]