Bug #104364 Workbench can't change configuration file
Submitted: 20 Jul 11:43 Modified: 20 Jul 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 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 12:02] MySQL Verification Team
Hello Pedro,

Thank you for the report and feedback.
Verified described.

regards,
Umesh