title: Syntax error updating mysql user password in mysql Server version: 8.0.21 MySQL Community Server - GPL
body: <p>I am trying to update the password of user == admin, my SQL version is <code>Server version: 8.0.21 MySQL Community Server - GPL</code></p>
  <pre><code>+------------------+
  | user             |
  +------------------+
  | admin            |
  | admin            |
  | mysql.infoschema |
  | mysql.session    |
  | mysql.sys        |
  +------------------+
  </code></pre>
  <pre><code>update user set authentication_string=PASSWORD('password@1234') where user='admin';
  ERROR 1064 (42000): 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 '('password@1234') where user='admin'' at line 1
  </code></pre>
  <pre><code>mysql&gt; UPDATE user 
      -&gt; SET authentication_string = PASSWORD('password@1234')
      -&gt; WHERE user = 'admin' AND 
      -&gt;       host = 'localhost';
  ERROR 1064 (42000): 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 '('password@1234')
  WHERE user = 'admin' AND 
        host = 'localhost'' at line 2
  </code></pre>
  <p>I have tried the above two and with password in place of authentication_string. It anyway should be authentication_string as the user table contain column with this only</p>