mysqlcheck: unknown variable 'max_allowed_packet=100M'

Question

I get the following error when I try to use mysqlcheck, mysqlrepair or mysqlanalyze:

mysqlcheck: unknown variable 'max_allowed_packet=100M'

I am trying to find whether there are any corrupt tables or indexes.

Background:

my.cnf

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
default-character-set = utf8
max_allowed_packet = 100M

Under [client]

[client] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set = utf8 max_allowed_packet = 100M Under [cliebt] — Dinesh Kumar Sarangapani, May 23, 2013 at 6:53
Remove max_allowed_packet = 100M from [client] Section and then execute mysqlcheck.Please have a look at bugs.mysql.com/bug.php?id=68313 — Abdul Manaf, May 23, 2013 at 7:00

Mat · Accepted Answer · 2013-05-23 07:01:32Z

2

According to this bug report (resolved as "not a bug"), you shouldn't put settings for mysqld in the [client] section of your .ini file.

Put the max_allowed_packet option in the [mysqld] section instead.

See Using Option Files for more details.

answered May 23, 2013 at 7:01

Mat

9,9894 gold badges42 silver badges40 bronze badges

1

...afaik it's a valid (and required for some purposes) setting for clients. I've got a database with an unreasonably large blob in it which clients can't retrieve unless both the client and server have the option. See it mentioned here: dev.mysql.com/doc/refman/5.5/en/packet-too-large.html
– pacifist
Oct 22, 2014 at 23:40

Add a comment |

sam · Accepted Answer · 2013-05-23 08:44:31Z

1

Add max_allowed_packet, open

my.ini/my.cnf under [mysqld] section.

Once the change is done you would have to restart the server

answered May 23, 2013 at 8:44

sam

112 bronze badges

Add a comment |

2 Answers 2