Bug #81783 grant privileges error

• Submitted: 9 Jun 2016 4:35
• Reporter: Clark So
• Status: Open
• Category: MySQL Server: Security: Privileges
• Severity: S4 (Feature request)
• Version: 5.7.13
• OS: CentOS (7.0)
• CPU Architecture: Any
• Tags: grant privileges plugin

[9 Jun 2016 4:35] Clark So

Description:
When I using grant command, it will be error on set password field.

so I use command as below:
"grant all privileges on `mydb`.* to 'username'@'127.0.0.1' identified by 'password';"

I check mysql.user table, the password will be set in plugin field.

How to repeat:
always

Suggested fix:
Set the password to authentication_string field, and auto set plugin with 'mysql_native_password'