Error executing the PASSWORD function in MYSQL SERVER (SQL SYNTAX ERROR 1064)

Error executing the PASSWORD function in MYSQL SERVE

I have the following query:

SELECT * 
FROM users 
WHERE login = 'FABIO' 
  AND pwd = PASSWORD('2018') 
LIMIT 0, 50000

You're giving this error:

  

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