Bug #104364 Workbench can't change configuration file
Submitted: 20 Jul 2021 11:43 Modified: 20 Jul 2021 12:02
Reporter: Pedro Pinheiro Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:8, 8.0.26 OS:Any
Assigned to: CPU Architecture:Any

[20 Jul 2021 11:43] Pedro Pinheiro
Trying to change the configuration file (edit connection->system profile->configuration file), but it's not editable (greyed out).

How to repeat:
edit connection->system profile->configuration file.
Can't edit.

Suggested fix:
Should be able to edit the configuration file

As a workaround:
1 - close workbench, if open

2 - make a backup server_instances.xml
      Usually located here: %AppData%\Roaming\MySQL\Workbench\server_instances.xml
3 - edit server_instances.xml and change the string:
<value type="int" key="sys.config.path.lock">1</value>
<value type="int" key="sys.config.path.lock">0</value>
4 - start workbench

5 - In Workbench edit your connection.
[20 Jul 2021 12:02] MySQL Verification Team
Hello Pedro,

Thank you for the report and feedback.
Verified described.

[10 May 2022 11:54] MySQL Verification Team
This bug is the original bug of the following one: