Special characters in mysql password

  • Resolved dccorp

    (@dccorp)


    7 years, 5 months ago

    Hi,

    The plugin is working fine with mysql external tables, but I was forced to create a new user for my database, with an alphanumeric only password, because I wasn’t able to put a complex password in the shortcode syntax (mysql://user:password@server/database).

    How could I use a complex password containing special characters like, for example “12/Ab@pl\Yh-” in the shortcode ?

    Thank you,

Viewing 1 replies (of 1 total)
  • Plugin Author Meitar

    (@meitar)

    That password contains two illegal characters in a connection URI, the / (the solidus) and the @ (the at-sign), which are both special characters for URIs. The first is of course the path separator, and the latter introduces a hostname when a username is given. Note also that the \ (the reverse solidus) is an escape character in a MySQL SQL statement, and if you set a MySQL user’s password with such a character it will need to be escaped in the SQL statement itself, otherwise you will actually be setting the password to the string 12/Ab@plYh- (note the absence of the reverse solidus) since the sequence \Y is not a valid escape character and thus is interpreted simply as Y. I believe this holds true for MariaDB as well but I am not sure.

    In any event, if you want to use these characters in a MySQL password with this plugin you will need to URL-encode them, since you are entering them in a connection URI context. Version 0.12.4 of this plugin, released tonight, should correctly handle URL-encoded MySQL passwords.

    Thanks for the bug report.

Viewing 1 replies (of 1 total)
  • The topic ‘Special characters in mysql password’ is closed to new replies.