title: Update user password in Mysql 5.7
body: <p>I wrote an installation script to change the root password with this SQL command:</p>
  
  <pre><code>UPDATE user SET password='*C563415623144561...' WHERE user='root';
  </code></pre>
  
  <p>This doesn't work on Mysql 5.7:
  <a href="http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-6.html#mysqld-5-7-6-account-management" rel="noreferrer">http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-6.html#mysqld-5-7-6-account-management</a></p>
  
  <p>My question is: how to change this command with another one compatible with 5.6 and 5.7 version of Mysql? I would like to update the password with a hashed string and not with a clear password.</p>