title: How to set block_encryption_mode for specific session based on user?
body: <p>I am trying to set the block encryption mode specific to a session based on the user but getting error on this command:</p>
  <pre><code>IF(SELECT CURRENT_USER()) = 'root' 
  THEN SET SESSION block_encryption_mode = 'aes-256-cbc'
  END IF;
  </code></pre>
  <blockquote>
  <p>You have an error in your SQL syntax; check the manual that
  corresponds to your MySQL server version for the right syntax to use
  near 'SELECT CURRENT_USER()) = 'root'  THEN SET SESSION
  block_encryption_mode = 'aes-2' at line 1</p>
  </blockquote>
  <p>How do I resolve this ?</p>