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
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S2 (Serious)
• Version: 5.1.49, 5.1.56
• OS: Any (Linux, Mac OS X)
• CPU Architecture: Any

[7 Feb 2011 14:33] Benson Margulies

Description:
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 
[client]
max_allowed_packet=10M
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.

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=585014