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)
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.3.5
• OS: Any
• 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.