Bug #95597 mysql_config_editor can not deal password with "#"

Description:
In our mysql environment, when the password with "#"(such as 'Cp#123'), use mysql_config_editor config the login-path. the login-path can not login success.

How to repeat:
mysql_config_editor can not deal password with "#"

mysql  Ver 14.14 Distrib 5.6.41, for Linux (x86_64) using  EditLine wrapper

[root@localhost ~]# mysql -s -utest -p
Enter password:     --Input: Cp#123
mysql>              --login success
mysql> exit

[root@localhost ~]# mysql_config_editor set --login-path=test --user=test  --host=localhost -p
Enter password:     -- Cp#123
WARNING : 'test' path already exists and will be overwritten. 
 Continue? (Press y|Y for Yes, any other key for No) : Y
[root@localhost ~]# 

[root@localhost ~]# mysql --login-path=test
ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: YES)   ---login failed
[root@localhost ~]#

[root@localhost ~]# my_print_defaults -s test
--user=test
--password=Cp         ----password is error
--host=localhost
[root@localhost ~]#

none

Hello li xichao,

Thank you for the report and feedback.
Verified as described with 8.0.16 build.

regards,
Umesh

The problem is that the .mylogin.cnf file interprets the # as the beginning of a comment.

A workaround is to quote your password when passing it to mysql_config_editor.
Type your password as:
"Cp#123"
instead of:
Cp#123

Note: if this issue ever gets fixed this workaround will break!

Posted by developer:
 
Fixed in 5.7.33, 8.0.23.

mysql_config_editor incorrectly treated # in password values as a
comment character.