the variable max_allowed_packet not able to be edited on MysQL 5.5

Question

I tried to change its value but in vain, in fact I didn't find my.ini but i found many files of configuration and i edited them all(I edited the value of max_allowed_packet under [mysqld] section. enter image description here But I didn't get the result; the variable has not been changed

Maybe my.ini is located in bin folder – Ivan Cachicatari Jun 16 '14 at 00:12 — Ivan Cachicatari, Jun 16 '14 at 00:12
I did not find it in /bin – Houssam Badri Jun 16 '14 at 07:20 — Houssam Badri, Jun 16 '14 at 07:20

score 2 · Accepted Answer · edited May 23 '17 at 12:05

2

Possible duplicate, please see if this can help to resolve your problem.

Also, Ivan is correct - the my.ini file should be in bin.

If the my.ini file cannot be found, any of the config files can be renamed to my.cnf to change MySQL's max_allowed_packet to the value of the max_allowed_packet variable in that config file.

edited May 23 '17 at 12:05

Community

1
1

answered Jun 16 '14 at 00:10

Zach H

257
1
3
15

I checked that answer before putting my question but it does not handle my problem – Houssam Badri Jun 16 '14 at 07:21
Have you searched the C drive for my.ini? – Zach H Jun 16 '14 at 12:11
Yes I did, but I think that all the 5 files above are config files – Houssam Badri Jun 16 '14 at 18:39
1

Yes. Those config files should have different values for the `max_allowed_packet`. If one of them suits your needs, try changing the name of it to **my.cnf**, then restart MySQL. – Zach H Jun 16 '14 at 22:06

Ivan Cachicatari · Answer 2 · 2014-06-16T08:15:37.850

-1

You can locate the my.ini file from service properties, just run services.msc and open MySQL service.

enter image description here

If you mysql installation run as process then my.ini will be found in c:\windows

edited Jun 16 '14 at 08:15

answered Jun 16 '14 at 07:55

Ivan Cachicatari

4,212
2
21
41

MySQL in my PC is not running as service, it is a process – Houssam Badri Jun 16 '14 at 08:11
Then maybe my.ini is in c:\windows – Ivan Cachicatari Jun 16 '14 at 08:12

the variable max_allowed_packet not able to be edited on MysQL 5.5

2 Answers2