title: MySQL alter view security
body: <p>I created a view with user root@'%' leaving the SQL SECURITY as the default DEFINER. Now that I deleted that user for security reasons, nobody else can access the view...</p>
  
  <pre><code>ALTER SQL SECURITY INVOKER VIEW view_x;
  </code></pre>
  
  <p>gives error "You have an error in your SQL syntax; check the manual... near '' at line 1"</p>
  
  <p>Here's the documentation on MySQLs website</p>
  
  <p>ALTER
      [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
      [DEFINER = { user | CURRENT_USER }]
      [SQL SECURITY { DEFINER | INVOKER }]
      VIEW view_name [(column_list)]
      AS select_statement
      [WITH [CASCADED | LOCAL] CHECK OPTION]</p>
  
  <p>Am I missing something obvious?</p>