MySQL: my.ini cannot be read

Question

I have MySQL 5.6 installed on Windows 7 64 bit and I cannot get it to read my my.ini file. I placed the file in the base installation directory, the Windows and C: \ directory, but it does not look like it is being read, although all the paths are listed here: http://dev.mysql.com/doc/refman/5.1/en/ option-files.html

My my.ini file does not do much, I just took my-default.ini as the base and added [Tuzdy] max_allowed_packet = 100000000 because this default limit for 4 MB is bad for BLOB.

When I run mysql.exe and check the variable, I find that it is still 4 MB, even after restarting the server (both through the services menu in the control panel and through mysqld -shutdown + mysqld -startup) and restarting Windows.

I have Windows 7, 64 bit. Can someone help me please?

Thanks in advance!

Alex

Answer 1

I started another thread on the MySQL forums, and the patient user was able to help me:

http://forums.mysql.com/read.php?10,595697,595697#msg-595697

This is not the most satisfactory solution because it essentially means reinstalling the server manually when you want to change something in the my.ini file, but at least it works somehow.

Answer 2

I faced the same problem. In my case, the service used my.ini from a different path (C: \ ProgramData \ MySQL \ MySQL Server 5.6 \ my.ini). You test it by examining the properties of the MySQLServer service in services.msc.

Answer 3

In MySQL Server 5.6, the location of my.ini is in ProgramData "C: \ ProgramData \ MySQL \ MySQL Server 5.6" not in the installation folder under the program files.

Be careful what Cosmus says. do not add a new line and do not forget the old line, and do not forget to restart the service.

Answer 4

I had the exact same problem, and the solution you sent from another thread was a bit confusing, and it really didn't solve the actual problem. I am sure that you did the same as me and added max_allowed_packet = 32M or something else in [mysqld], as each site says. Although this is completely correct, people forgot to mention, and it took me a week to finally understand that the default my_ini file was already set to max_allowed_packet = 4M. I didn’t notice this completely, because each [mysqld] line is commented so much. Obviously, since the source file max_allowed_packet = 4M looked like 2 pages down from the [mysqld] header, it overloads any settings that you manually insert.

Answer 5

Sharing my results after a lot of time lost. I always had to read the manual first. This is straight from the manual. In my case, the my.ini file was in the C: \ ProgramData \ MySQL folder

om /LIdVr.png

More information can be found below https://dev.mysql.com/doc/refman/5.7/en/option-files.html