title: In MySQL SERVER 8.0 the PASSWORD function not working
body: <p>Error while executing the <code>PASSWORD</code> function in MySQL Server version 8.0.12</p>
  
  <p>I have the following query:</p>
  
  <pre><code>SELECT * 
  FROM users 
  WHERE login = 'FABIO' 
    AND pwd = PASSWORD('2018') 
  LIMIT 0, 50000
  </code></pre>
  
  <p>I am getting this error:</p>
  
  <blockquote>
    <p>Error Code: 1064. 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</p>
  </blockquote>