Bug #3234 trim spaces from username for dumb clients
Submitted: 18 Mar 2004 14:53 Modified: 2 Dec 2005 16:57
Reporter: Timothy Smith Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version: OS:Any (all)
Assigned to: CPU Architecture:Any

[18 Mar 2004 14:53] Timothy Smith
At least one program which uses MySQL (courier-imap) potentially does something lame:

> Access denied for user: 'courier              @localhost' (Using password: YES)

It might be nice to strip blanks from the beginning and ending of the user name, to work around the dumb client.

How to repeat:
$ mysql -uroot\ 
ERROR 1045: Access denied for user: 'root @localhost' (Using password: YES)
[2 Dec 2005 16:57] Valeriy Kravchuk
Thank you for a reasonable feature request. The idea of trimming trailing space passed by some clients is clearly worth implementation.