20 Indispensible MySQL Resources
Anyone who’s spent more than 5 minutes on the MySQL documentation will realise it leaves a lot to be desired. The same goes for many of the 3rd party apps latched onto this platform which offer mediocre functionality and anything beyind the basic comes at a huge premium.Well here’s a set of 20 resources, tools, articles that hope to break that and bring it all under one roof. Enjoy.
- MyDB Studio – Makes a useful administration app for MySQL and also has some design capabilities such as the SELECT wizard to help with overly complicated queries.
- SQLYog – Provides an excellent GUI for designing and administrating you MySQL database.
- WWW SQL Designer – A really funky Ajax database designer. It has many features normally only available in offline apps. It’s got a lot of promise although its still being very actively developed it’s stable and fast.
- OpenOffice.org Base – I know its certainly an unusual one to incude in the list but OpenOffice Base does have good support for working on a MySQL system using its Java interface. Worth a look but if you have a huge database then it can take a performance knock.
- AutoMySQLBackup – Why go to the special effort of producing scripts to backup when you can use this.
- PHPMyAdmin – Been around for years and still going strong. Its not the most speedy when handling large sets of data (try offline apps such as SQLYog or MyDB) but its got every functionality you can shake a stick at.
Security Tools
- SQLIer – A SQL injection tool which you provide a URL and it does all it can to perform SQL injection.
- SQLMap – A blind SQL injection tool. It provides support for PostgreSQL, MSSQL as well as MySQL.
- Absinthe – An application which is available on Linux and Windows. It provides MySQL injection brute forcing on your server.
- SQID – SQL Injection Digger was created in Ruby as a command-line tool for brute force SQL injection testing.
Optimising MySQL
- MySQL Performace Blog – For regularly updated information on optimising your MySQL install.
- SQL Commandments – 25 rules of optimized database design.
- 10 Tips on Optimizing MySQL – From 20bits.
- Another 10 Tips – They just keep on trucking with those optimisation tips.
Knowledge
- MySQL Tutorials – Great collection of MySQL tutorials.
- MySQL Cheat Sheet – Provided by the prolific producer of cheat sheets over at I Love Jack Daniels.
- 10 Common Mistakes of MySQL Design – Learn what not to do!
- MySQL Clustering How-To – Exactly what it says.
- MySQL Master-to-Master Replication – If you need to setup replication in a ring then this is your place.
- MySQL vs. Postgre – Its good to compare.
If you think I’ve missed anything off then leave a note in the comments and I’ll make the list grow. 
Related posts:
I wonder why Navicat, http://www.navicat.com is not one of your Indispensible MySQL Resources.
I used phpmyadmin before but recently switched to Navicat due to its intuitive interface and powerful import/export features.
I am using its free Lite version. Worth to take a look.
http://www.navicat.com/download.html
I was wondering if you can add my tutorial blog to the list as it is building to be a great resource for mysql and more.
hi, i wonder why sqlyog is not security tool. just try with it. i am fan of sqlyog cause of its service and its stability and compatibility and also it has more secured features.
Can i add your blog link to my website. I am fan of sqlyog and it is building to be a great resource for mysql and developers..
hi frendz, Rozy and Dubai are absolutely rite where i find sqlyog to be best db management tool and their improved gui and fast tool. even offers free community. Just all of you guyz play with this!!!
Nice and informative post.
Great list of resources. Thanks for sharing.
Cool list. Thanks to sharing.
Please consider adding our web site to your list of MySQL resources. We have over 750 pages of documentation with easy to understand examples. We also have many tutorials for beginners and intermediate level MySQL developers and administrators.