Error with handling passwords with symbols

[ghost]

When connecting to my remote database with a mysql client I had no problem, but connecting through Mysql2 I keep getting access denied.

I was able to figure out the reason. For some reason or another Mysql2 doesn't properly handle symbols in passwords. In this instance, I had the symbol '$' in my password which was messing something up.

I am unsure if this was intentional and written down somewhere but I found no documentation restricting password characters, and again, it worked with the mysql client.

[sodabrew]

Sounds like a bug. Version of mysql2 gem that you're using?

[ghost]

Looks like mysql2, 0.3.14.

[sodabrew]

Please try mysql2 0.3.13 as well, let's see if this was a recently introduced issue.

[ghost]

Unfortunately it was on a production system so I can't easily test that. I can try to reproduce it on 0.3.13 on another system later.

If it helps, the symbol was at the start of the password ex: "$foobar1234"

[sodabrew]

Are you still seeing this problem? I'm not able to reproduce it.

[sodabrew]

Closing for lack of updates.

[ghost]

I think it can be closed, the error may have been mine. I was storing the password within an environment variable, ex: foo=$asdf. The problem seems to be the "$" wasn't escaped, it should have been: foo=$asdf.