MySQL Bugs: #87215: Problem with Bug #84564

Bug #87215	Problem with Bug #84564
Submitted:	27 Jul 2017 1:33	Modified:	8 Aug 2017 7:53
Reporter:	镇熙林	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S1 (Critical)
Version:	5.7.16	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	84564

Description:
With brand new MySQL Server, there is only one root user ('root'@'localhost'), with grants below:
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
    GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;
Now I want to create a 'root'@'%' user with same privileges. So I run the scripts below:
    CREATE USER 'root'@'%' IDENTIFIED BY 'root';
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
    GRANT PROXY ON ''@'' TO 'root'@'%' WITH GRANT OPTION;
But this will trigger the bug 84564!
How can I create a 'root'@'%' user with same privileges?

How to repeat:
see Description

Please do not submit the same bug more than once. An existing bug report  Bug #84564(another one which you have reported Bug #86806)already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

I add comment at [12 Jul 8:49], but no one replied!