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
• Status: QA review
• Category: MySQL Workbench: Administration
• Severity: S3 (Non-critical)
• Version: 6.3.3, 6.3.4
• OS: Any
• CPU Architecture: Any

[15 Jun 2015 19:45] Tony Holmes

Description:
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.

Thanks,
Umesh