title: mysql workbench disable definer
body: <p>I've been using mysql in linux since they have the mysql workbench which add speed on development. </p>
  
  <p>It has synchronize method which is good. Now I have three database for a development my own computer, test server, and development server.</p>
  
  <p>Updating table from one server to another is easy using the synchronize method, but for trigger, procedure ( routines ), event and function is like hell.</p>
  
  <p>For above type mysql workbench automatically add "DEFINER" stuff whenever you create or alter it, which of course will be different in each server. And due to that during synchronization, I must edit manually or else it will always be failed. Selecting option "Ignore check definer" also not working.</p>
  
  <p>I don't like using mysqldump because I cannot automatically generate the change, it's problematic to create "ALTER" command every time during development. There is some tool in web, but it introduce new problem than solving one.</p>
  
  <p>For function and routines every time before updating the other server I just login to mysql console and run this</p>
  
  <pre><code>update mysql.proc set definer = '' where db = &lt;my db&gt;
  </code></pre>
  
  <p>Then this will update my model in mysql workbench and remove all definer string. But for trigger there is no easy way, and I cannot update INFORMATION_SCHEME.TRIGGERS cause it's only a view like table.</p>
  
  <p>I have 50+ table with 1-2 trigger each. That is a waste of time to edit one by one. And am prefer to use one tool only for all.</p>
  
  <p>Perhaps we can disable this function in mysql workbench ?</p>