Details
Minor
Description
When I have a # character in my password, and try to use a .cnf file for auto login, the parser seems to strip all characters after the hash in the cnf file.
I believe it's some kind of "comment stripper" in the code that's the culprit.
Since the # char is perfectly valid for passwords everywhere else (working in php, entered on command line, etc), the mysql client should at least yield a warning when finding a comment char in a password in some cnf file.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
As usually with valid yet not completely innocent symbols, enclosing the string into quotation marks solves the problem:
[client] host=mysql.example.com password='abc#123'
It is also explicitly documented in MySQL manual: https://dev.mysql.com/doc/refman/5.5/en/option-files.html
#comment, ;comment
Comment lines start with “#” or “;”. A “#” comment can start in the middle of a line as well.
opt_name=value
This is equivalent to --opt_name=value on the command line. In an option file, you can have spaces around the “=” character, something that is not true on the command line. You can optionally enclose the value within single quotation marks or double quotation marks, which is useful if the value contains a “#” comment character.
Would be nice if it worked, but it doesn't. At least not my 10.0.10 server
Forgot to add correct host while testing.
It works, but I still mean that it should be some warning here.
It would be nice to be able to turn this bug into a feature request, but I can't find the way..
This is valid and documented behavior. MariaDB doesn't have any way to distinguish between an intentional comment or an unquoted hash character, so it has to rely on the user for that.
Forgot to add example of my cnf file.
Working:
[client]
host=mysql.example.com
password=abc123
Not working:
[client]
host=mysql.example.com
password=abc#123