What Happened to phpMyAdmin?

For as long as I’ve been working on websites that require MySQL databases, I’ve been working with phpMyAdmin. It does what I need it to do, and I probably only use a quarter of what it offers. I had noticed a year or two ago that the new version of phpMyAdmin was quite a bit different than what I was used to, and had resisted adopting the new version for as long as possible. Unfortunately, I’m now using the dreadful version 3.5.7.

Continue reading

Enable General and Slow Query Logging

As I work with applications that use a MySQL database, I have various ways to check my actual queries, but MySQL makes it really easy to log queries and slow queries. Since my dev machine is 64-bit Windows 7, and I’m running XAMPP 1.8.0, I just needed to add a few lines to MySQL’s my.ini file, and turn the query logging on in phpMyAdmin.

UPDATE: Since adding XAMPP 1.8.3, slight changes have been necessary. See details at end of post.

Continue reading