Bug #81783 grant privileges error
Submitted: 9 Jun 2016 4:35
Reporter: Clark So Email Updates:
Status: Open Impact on me:
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:5.7.13 OS:CentOS (7.0)
Assigned to: CPU Architecture:Any
Tags: grant privileges plugin

[9 Jun 2016 4:35] Clark So
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'@'' identified by 'password';"

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

How to repeat:

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