Bug #67772 MySQL Workbench administration: doesn't do sudo for log file viewing
Submitted: 30 Nov 2012 18:29 Modified: 7 Mar 2013 20:05
Reporter: B. T. Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.44 OS:Linux
Assigned to: CPU Architecture:Any

[30 Nov 2012 18:29] B. T.
Description:
The server is openSUSE running MySQL 5.5.25a.
Our IT has disabled root as SSH user on purpose, so su and sudo are the only options. I've configured Workbench to SSH using non-root user and enabled the sudo for configuration option.

However, it fails to read the log file due to permissions (our /var/log/mysql and contents, including mysqld.log, only has root access for security purposes), even if I enable sudo for status commands. Incredibly, Workbench has no setting allowing sudo for viewing the log file, even though it does for the status commands. Why?

How to repeat:
Set Workbench to SSH as non-root user and have mysqld.log as root:root with -rw-rw----. In administration, fails to display log file due to permissions.

Suggested fix:
Add a third "Acquire administrator rights to..." option in the settings that will make it do so for the log file.
[7 Feb 2013 20:05] Miguel Solorzano
Please try version 5.2.46. Thanks.
[8 Mar 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".