Bug #70504 service_manager user is configured with unnecessary access to bundled server

• Submitted: 3 Oct 2013 9:28
• Modified: 9 Jan 2015 10:16
• Reporter: Simon Mudd (OCA)
• Status: Closed
• Category: MySQL Enterprise Monitor: Installing
• Severity: S3 (Non-critical)
• Version: 3.0.1.2893
• OS: Any
• CPU Architecture: Any

[3 Oct 2013 9:28] Simon Mudd

Description:
I installed the dashboard with a bundled MySQL db.
I noticed that after this install the service_manager user seems to have copied the "root" user and had multiple grants configured. This is completely unnecessary since the instance is local.

How to repeat:
* Install the dashboard
* suggest the service manager username as say service_manager.
* check the rights after having done this.

You'll see:

'service_manager'@'127.0.0.1'
'service_manager'@'::1'
'service_manager'@'my.fully.qualified.hostname.com'
'service_manager'@'localhost'

Suggested fix:
Given you install the bundled MySQL server configure it with proper grants,
and then configure the service_manager with a single user that's probably "localhost", using a socket.

[4 Oct 2013 8:24] MySQL Verification Team

Hello Simon,

Thank you for the bug report.

Thanks,
Umesh