When making massive changes to multiple templates within Expression Engine, we use a product called MySQL Studio available from Navicat in versions for Windows, Macintosh, and LINUX. The product allows you to manipulate MySQL tables using a graphical user interface and provides security over SSH. Beats the pants off of phpMyAdmin … in my humble opinion.
The query statement to change all templates to php_allow=“yes” is this:
Likewise the query statement to change the input parse method to input is this:
Of course, you don’t need Navicat to do this. You can also implement this query by calling up MySQL using a command line.