Connection fails when the password contains % or ? characters

[erolatreston]

MySQL is created using the mysql_native_password plugin.
If the password contains % or ? characters, authentication seems to fail.

Host operating system: output of uname -a

Linux foo.example.com 3.10.0-1062.12.1.el7.x86_64 #1 SMP Tue Feb 4 23:02:59 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

mysqld_exporter, version 0.11.0 (branch: HEAD, revision: 5d71796)
build user: root@3d3ff666b0e4
build date: 20180629-15:00:35
go version: go1.10.3

MySQL server version

5.7.29

mysqld_exporter command line flags

Environment=DATA_SOURCE_NAME=exp:Abc123!#%^&*()_+[;.?|@(localhost:3306)/

What did you do that produced an error?

change password to contain % or ?

What did you expect to see?

connection established

What did you see instead?

connection failed

[gnufree]

Your password setting is too complex. You can consider removing some special symbols.