Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


  • MySQL Ver 14.14 Distrib 5.5.24, for Linux (x86_64) using readline 5.1
  • I used the command mysqlcheck -u xxxx -h -d xxxx -p xxxxx


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

Under [client]

share|improve this question
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set = utf8 max_allowed_packet = 100M Under [cliebt] – Dinesh Kumar Sarangapani May 23 '13 at 6:53
Thanks Mat i added it.. – Dinesh Kumar Sarangapani May 23 '13 at 6:59
Remove max_allowed_packet = 100M from [client] Section and then execute mysqlcheck.Please have a look at – Abdul Manaf May 23 '13 at 7:00
up vote 1 down vote accepted

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.

share|improve this answer
...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: – pacifist Oct 22 '14 at 23:40

Add max_allowed_packet, open

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

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.