Error 1049 Unknown database '&lock_wait_timeout=2'

[wk60807430]

Host operating system: output of uname -a

localhost

mysqld_exporter version: output of mysqld_exporter --version

0.11.0.linux-amd64

MySQL server version

5.7.22

mysqld_exporter command line flags

./mysqld_exporter --config.my-cnf=".my.cnf"

What did you do that produced an error?

i want to start mysqld_exporter

What did you expect to see?

run

What did you see instead?

ERRO[0012] Error pinging mysqld: Error 1049: Unknown database '&lock_wait_timeout=2' source="exporter.go:119"

cat .my.cnf
[client]
host=localhost
port= 3306
user=root
password=*******

[wk60807430]

its so wired pls help me

[SuperQ]

Hrm, this is coming from connection string builder. Does your password have a '?' in it?

[wk60807430]

yes man its have a '?' in it

[SuperQ]

I thought so, that's a bug in the current way we handle building the connection string.

For now, I would recommend creating a separate user for the exporter that does not have a ? in the password.

[wk60807430]

ok，tks

[MahaGamal]

I hit the same issue with a password have @ after changing it's working fine