Complex passwords may cause authentication issue with MySQL

[nachtkinder]

Hi,

I'm new to using mycli and have noticed that it does not seem to cope well with some complex passwords.

A few of the MySQL user accounts that I have access to have complex passwords that contain extended characters some of which have meaning in BASH (e.g. $, {, }, [, ], (, ) ). When attempting to connect with any of these users providing the password inline, as part of a DSN or in response to the prompt the connection fails with connection refused (error 1045). However, if I use the -g option to supply a login-path name for the user mycli connects. I have tried double-quoting and escaping the characters using \ but to no avail. Users with simpler alphanumeric passwords do not have this issue.

OS: Ubuntu Linux 20.04 mycli: 1.24.1 MySQL server version: 5.7.33 Community version

Regards,

-- nachtkinder