Recently, I was tasked to add a MySQL database GUI for a client and came up against an issue where the database server wasn’t properly configured to accept remote connections.

If you manage a database server, you are probably always in search of a tool to make that process a bit easier. If your database of choice is MySQL, you have a number of options.

We are developing a VB6 application that uses MySQL as it's database. The tables are InnoDB. How do we check to see if a record/table is locked before we do a SELECT * FROM tablename WHERE ...