How to set autocommit Off

I have a db user, john, who don't have SUPER privilege. 

I'd like john have no autocommit when connecting Cloud SQL.

As I know, to cause clients to begin with a default off, need to set the server's "init_connect" system variable.

(ref: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_autocommit)

How can I do? or no support now?

thanks, 

-Pay