title: What should I use instead of 'password' in a future release
body: <p>When issuing the statement:</p>
  <pre><code>mysql&gt; update user set authentication_string=password('11111') where user='root'; 
  </code></pre>
  <p>I get the response:</p>
  <blockquote>
  <p>Query OK, 0 rows affected, 1 warning (0.00 sec) Rows matched: 1  Changed: 0  Warnings: 1</p>
  <p>Warning (Code 1681): 'PASSWORD' is deprecated and will be removed in a future release.</p>
  </blockquote>
  <p>What should I use instead of 'password' in a future release?</p>