Bug #41491 MEM/proxy manual should clearly state that changes in grants are often needed

• Submitted: 16 Dec 2008 9:44
• Modified: 6 Jan 2009 13:47
• Reporter: Johan Idrén
• Status: Closed
• Category: MySQL Enterprise Monitor: Documentation
• Severity: S2 (Serious)
• Version: 2.0.0.7111
• OS: Any
• Assigned to: MC Brown
• CPU Architecture: Any

[16 Dec 2008 9:44] Johan Idrén

Description:
In the documentation for MEM 2.0, the following is stated

"You do not need to change or specify different login credentials. The agent will pass on the login and password details that you supply to the original MySQL server without modification."

This is incorrect as the agent will NOT pass on the details for the originating host. The above statement would only be true if all users used 'user'@'%' grants, ie allowing connections from all hosts, which most don't.

How to repeat:
Read https://enterprise.mysql.com/docs/monitor/2.0/en/mem-query-analysis.html#mem-query-analysi...
Attempt to connect as a user with a grant other than 'user'@'%', do not receive your promised grants.

Suggested fix:
Clearly state how connecting via proxy affects the way your connections look to the server (all coming from localhost). Preferably with big red letters as this is very important.

[6 Jan 2009 13:47] MC Brown

The documentation has been updated to point out that the credentials need to be adjusted.