MySQL Bugs: #77363: Workbench PS Helper install assumes presence of root@localhost

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:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	6.3.3, 6.3.4	OS:	Any
Assigned to:		CPU Architecture:	Any

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.

Hello Anthony Holmes,

Thank you for the report.

Thanks,
Umesh

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.