MySQL Bugs: #82465: Cannot create user account

Bug #82465	Cannot create user account
Submitted:	5 Aug 2016 2:55	Modified:	5 Aug 2016 5:20
Reporter:	Lee ed	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S2 (Serious)
Version:	mysql Ver 14.14 Distrib 5.7.13, for Lin	OS:	Ubuntu (Linux mars 4.4.0-31-generic #50-Ubuntu SMP Wed Jul 13 00:07:12 UTC 2016 x86_64 x86_64 x86_64 GNU/Lin)
Assigned to:		CPU Architecture:	Any
Tags:	account, grant, user

Description:
I created user by following line.
mysql> grant usage on test.* to test@localhost identified by 'test';

You can see wrong password and plugin as this.
mysql> select user,password,plugin from user where user='test';
+------+----------+-------------------------------------------+
| user | password | plugin                                    |
+------+----------+-------------------------------------------+
| test |          | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |
+------+----------+-------------------------------------------+
1 row in set (0.00 sec)

How to repeat:
Always

Suggested fix:
The password should be in 'password' column.

Hello Lee ed,

Thank you for the report.
This is duplicate of Bug #79622, please see Bug #79622.

Thanks,
Umesh