Bug #113520 Options file not showing in administrative tab in workbench for mysql community
Submitted: 27 Dec 2023 21:09 Modified: 28 Dec 2023 12:59
Reporter: Ronald Radowich Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.2 OS:Windows
Assigned to: CPU Architecture:x86

[27 Dec 2023 21:09] Ronald Radowich 
Description:
I wanted to add a path to innodb directories. when I pressed the option file in the administration tab I got the following message "Location of MySQL configuration file (ie: my.cnf not specified.

I went to C:\ProgramData\MySQL\MySQL Server 8.2 and the my.ini file was there. I opened the my.ini file in Notepad++ and added the path
innodb_directories = "F:\mysql_8_2_databases;H:\mysql_8_2_databases"; I saved the file and restarted the mysql 8.2 server.
 
I ran query SELECT @@datadir,@@innodb_data_home_dir,@@innodb_directories;

the result was '"F:\mysql_8_2_databases;H:\mysql_8_2_databases";'

So the server read the my.ini file on restart.

I went to the options menu option of the administrative tab and found the same message; file not found.

How to repeat:
Follow what I did in the description.

Suggested fix:
Unknown.
[28 Dec 2023 12:59] MySQL Verification Team 
Hello Ronald Radowich,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil