Bug #87107 "Install Helper" connection is denied with password end with '#'
Submitted: 19 Jul 2017 5:22 Modified: 19 Jul 2017 7:06
Reporter: Meiji Kimura Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:6.3.x, 6.3.9 OS:Any
Assigned to: CPU Architecture:Any

[19 Jul 2017 5:22] Meiji Kimura 
Description:
When Workbench connect to MySQL 5.6 (without sys shema) and select PERFORMANCE section, Message is 'The Performance Schema helper schema(sys) is not installed'.

Then pushed 'Install Helper' will be sys schema installed.

But the connection's password uses end with '#', sys installer show errors like this.

Error installing sys Schema.
ERROR 1045(28000): Access Denied for user 'msandbox'@'localhost' (using password: YES)

At that time I use these user & password pair

User: msandbox
Password: msandbox#

How to repeat:
(1) Make user have all privilege and use password end with '#'.
(2) Connect to MySQL 5.6( with no sys schema)
(3) select PERFORMANCE and push 'Install Helper'

Suggested fix:
Should work with password end with '#'.
[19 Jul 2017 7:06] MySQL Verification Team 
Hello Meiji-San,

Thank you for the report and feedback!

Thanks,
Umesh
[15 Jan 2018 2:55] MySQL Verification Team 
See Bug#74691 for mysql_config_editor's case.
[13 Jan 2021 6:51] MySQL Verification Team 
Another case of mysql_config_editor, Bug#95597