Bug #77363 Workbench PS Helper install assumes presence of root@localhost
Submitted: 15 Jun 2015 19:45 Modified: 24 May 2018 15:32
Reporter: Tony Holmes Email Updates:
Status: QA review Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:6.3.3, 6.3.4 OS:Any
Assigned to: CPU Architecture:Any

[15 Jun 2015 19:45] Tony Holmes
When installing PS_Helper via MySQL Workbench, the DEFINER clauses all assume the presence of root@localhost account in order to finalise installation of ps_helper.  MySQL security best practices indicate that people should consider renaming the root account to minimise risk exposure; this breaks ps_helper install from Workbench.

How to repeat:
Remove root@localhost account and setup another (admin, etc), then try and install ps_helper from within workbench.

Suggested fix:
Use the config builder as provided by Mark Leith during installation, or alternatively allow or at least check "if exists" root@localhost and fail with a useful error message and without doing other stuff like changing sys.version when DEFINERs are not updated.
[16 Jun 2015 8:38] MySQL Verification Team
Hello Anthony Holmes,

Thank you for the report.