Bug #75927 SET PASSWORD=PASSWORD(...) SHOULD be supported, but deprecated.
Submitted: 17 Feb 2015 8:52 Modified: 25 Feb 2015 13:12
Reporter: Georgi Kodinov Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:5.7.6 OS:Any
Assigned to: CPU Architecture:Any

[17 Feb 2015 8:52] Georgi Kodinov
Currently SET PASSWORD = PASSWORD () is removed as syntax. It should still be present, but deprecated.

How to repeat:
mysql> set password=password('a');
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('a')' at line 1

Suggested fix:
should throw a deprecation warning instead.
[18 Feb 2015 5:55] Umesh Shastry
Bug #75928 marked as duplicate of this
[25 Feb 2015 13:12] Paul Dubois
Noted in 5.7.7 changelog.

SET PASSWORD ... = PASSWORD('auth_string') syntax was to be
deprecated in MySQL 5.7.6, but was made illegal. This syntax is now
available again, but generates a warning due to its deprecated status.
These alternatives remain available, the first of which now should be
considered the preferred form:

ALTER USER ... IDENTIFIED BY 'auth_string';
SET PASSWORD ... = 'auth_string';