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:
None 
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 
Description:
Hi,
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>
--------------------------------
to:
--------------------------------
<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.

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

https://bugs.mysql.com/bug.php?id=103332