Thankfully, MySQL offers a handy command that goes a very long way to improve the security of your MySQL installation. This single command will: update the password plugin; ...

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 ...