I also got into the more nitty-gritty nuances of mysql through with phpmyadmin. Many things I find being done on client side "dashboard" applications can be handled by a mysql view, which can then be pulled up in phpmyadmin.
Have to say phpmyadmin is underappreciated. Guess a bit of UI makover can do wonders for it.