我使用的是MYSQL5.7,它是使用Windows中的msi选项安装的。我想要更改innodb_buffer_pool_size。我检查了stackoverflow,找出了如何更改mysql.ini文件。
对于MYSQL5.7,我尝试更改下面位置中的my.ini文件,如堆栈溢出中所述。
Option1;
C:\Program Files\MySQL\MySQL Server 5.7. I made the changes in the my-default.ini file and stopped the mysql service and started again. Its not working
So i copied the my-default.ini to my.ini and tried again. Its not workingOption2:
I echo the programdata, then i found another location. C:\ProgramData\MySQL and in that i found 4 ini files. I changed everything and stopped and started the MYSQL service. Its also not working.
Please help me to understand why the ini file is not reflected and how to resolve this issue发布于 2021-03-10 22:44:49
将my.ini文件保存在stall mysql位置,然后运行net stop mysql、net run mysql。如果net run mysql没问题,那么my.ini也没问题。
https://stackoverflow.com/questions/42450766
复制相似问题