Re: server on development machine

[Kimber Barton]

Thanks again. When I try to edit the options file from workbench, I got the following error:
Location of MySQL configuration file (ie: my.cnf) not specified
All options such as "Locate option" are grayed out

So I used trusty google and found out how to tell workbench where it is and did that.

(On my machine, the my.ini file is located at:
C:/ProgramData/MySQL/MySQL Server 8.0)

Restarted the server and now I get the following error when trying to open the options file in workbench:

Error opening configuration file
UnicodeDecodeError: ‘charmap’ codec can’t decode byte 0x9d in position 4329: character maps to <undefined>

From looking online the 0x9d character is the "smart" single quote in windows. But there are no single quotes in my.ini.

Once I "ok" this error, it does open the my.ini file.

But, I do not see innodb_buffer_pool_size there at all. I do see innodb_buffer_pool_chunk_size. I also do not see innodb_buffer_pool_instances.

Thanks again for all your help.
Kimber