How to turn off mysql strict mode using sequel pro

[Michael Norman]

Does anyone have an idea of how to turn off "strict mode" using sequel pro? 

I would like to do so on a mac mini server that is colocated. 

Thanks for any help you can provide. 

[Jakob Egger]

To turn it off for the current connection only, execute the following query in the custom query tab:
SET sql_mode = '';

If you want to turn it off permanently and for all connections, you have to edit the configuration file "my.cnf"
More info: http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html

Best regards,
Jakob Egger

> --
> You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to sequel-pro+...@googlegroups.com.
> To post to this group, send email to seque...@googlegroups.com.
> Visit this group at http://groups.google.com/group/sequel-pro.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>