Bug #59987 mysqlshow reject max_allowed_packet in my.cnf
Submitted: 7 Feb 2011 14:33 Modified: 7 Feb 2011 15:21
Reporter: Benson Margulies Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:5.1.49, 5.1.56 OS:Any (Linux, Mac OS X)
Assigned to: CPU Architecture:Any

[7 Feb 2011 14:33] Benson Margulies
hercules% which mysqlshow
hercules% mysqlshow -v
mysqlshow: unknown variable 'max_allowed_packet=1G'

mysqlshow refuses to run if my.cnf has a max_allowd_packet setting.

How to repeat:
1. put max_allowed_packet=1G into my.cnf.
2. try to run mysqlshow.
[7 Feb 2011 15:21] Valeriy Kravchuk
Verified just as described with current mysql-5.1 on Mac OS X:

bin/mysqlshow: Mach-O executable i386
macbook-pro:5.1 openxs$ cat /tmp/my.cnf 
macbook-pro:5.1 openxs$ bin/mysqlshow --defaults-file=/tmp/my.cnf -V
bin/mysqlshow: unknown variable 'max_allowed_packet=10M'
macbook-pro:5.1 openxs$ bin/mysqlshow -V
bin/mysqlshow  Ver 9.10 Distrib 5.1.56, for apple-darwin9.6.0 (i386)
[7 Feb 2011 15:45] Peter Laursen
strange .. I cannot reproduce on Windows with 5.1.54
[8 Feb 2011 8:28] Valeriy Kravchuk
As for Windows:

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqlshow -uroot -proot -P3310 -V
mysqlshow  Ver 9.10 Distrib 5.1.54, for Win32 (ia32)

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqlshow --no-defaults --max-allowe
d-packet=10M -uroot -proot -P3310 -V
mysqlshow: unknown variable 'max-allowed-packet=10M'

Just put this variable into [client] section in my.ini, and mysqlshow will read it and fail.
[21 Mar 2012 20:04] Nicholas Bamber
We have similar reports.