Alexander Kuznetsov's fixes from https://rt.cpan.org/Ticket/Display.html?id=77648 (his notes below) and also clean-ups I had laying around not committed because I'm an idiot; probably not in a working state

CHIDriverTests-MySQLHandlerSocket.t does not allow to specify remote
MySQL host. Attached please find a QND fix for this issue. The database
can be entered in a form "XXX:host=YYY"

The patch also allows to have all CHI tests passed.

Besides immediate bug fixes it creates tables using InnoDB, as MyISAM
seems to be inappropriate. Please see the details -
http://www.pablowe.net/2011/03/handlersocket-edge-cases/

One outstanding issue remains -
CHI/Driver/HandlerSocket/t/CHIDriverTests/Base.pm wants CHI::Driver::DBI
to be installed, otherwise fails. While CHI::Driver::DBI does not seem
to be necessary for CHI::Driver::HandlerSocket, I am not sure if it is
mandatory for proper CHI operation.