Bug #79121 WB doesn't recognize valid ALTER USER syntax
Submitted: 4 Nov 2015 15:32 Modified: 8 Dec 2015 1:18
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.5 OS:Any
Assigned to: CPU Architecture:Any

[4 Nov 2015 15:32] Todd Farmer
Description:
When the following SQL command is entered in Workbench's SQL Editor, it shows a syntax error on the "BY" keyword:

ALTER USER u@localhost IDENTIFIED WITH sha256_password BY 'test';

The syntax is valid, and executes without error.

How to repeat:
ALTER USER u@localhost IDENTIFIED WITH sha256_password BY 'test';

Suggested fix:
Adjust syntax to be aware of the BY clause.
[8 Dec 2015 1:18] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.6 release, and here's the changelog entry:

The "BY" keyword is now supported.

Thank you for the bug report.