Bug #26312 mysqldump and other tools should ignore prompt configuration option
Submitted: 13 Feb 2007 10:30 Modified: 13 Feb 2007 11:26
Reporter: Jacques Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:5.0.33 OS:Any
Assigned to: CPU Architecture:Any

[13 Feb 2007 10:30] Jacques
Description:
MySQL command line tool allows for setting a prompt: 

[client]
prompt=(\u@\h) [\d]>\_

What I'd expect is:

$ mysqladmin ping
mysqld is alive

How to repeat:
Add the following to ~/.my.cnf:

[client]
prompt=(\u@\h) [\d]>\_

mysqladmin ping
mysqladmin: unknown variable 'prompt=(\u@\h) [\d]>\_'

Suggested fix:
Ignore prompt value if using mysqladmin, mysqldump, etc.
[13 Feb 2007 11:26] Sveta Smirnova
Thank you for the report.

Verified as described.
[18 Dec 2008 15:20] MySQL Verification Team
Moving the prompt from [client] to [mysql] would prevent the error.