I am sure there is a better way to do this, but...

In db.py, _parse_connection_string function, it would
be nice to have the ability to use 'client_flag'. This
is so we can use MySQL 5.x with stored procedures in
Zope. In Python, simply specifying the connection
option for client_flag is fine, but the Zope DA doesnt
give us that ability. Here is the lines I have added
(I believe line 234):

---------------

if not items: return kwargs
kwargs['client_flag'], items = int(items[0]), items[1:]

---------------

This is just before the checking for 'unix_socket'
argument. (because, IMHO, you would want to specify
client_flag more often than unix_socket)

Maybe this is best implements as a checkbox option or
something else, but for me this at least works good.

One other thing to note, you must use a '-' (dash)
right before your connection string to disable
transaction. Not sure why, but it wouldnt work
properly using stored procedures without that.

My blog has more info:
http://www.1stbyte.com/site/blogs_dtml?#blog22

Basically I want client_flag to be specified on the
connection string like so:
-adatabase auser apassword 65536

This enables MULTI_STATEMENTS.

Thank you.

Greg