Bug #95597 mysql_config_editor can not deal password with "#"
Submitted: 2 Jun 9:37 Modified: 3 Jun 12:19
Reporter: li xichao Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.6 5.7, 5.7.26 OS:Linux
Assigned to: CPU Architecture:Any

[2 Jun 9:37] li xichao
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 ~]#
[2 Jun 9:42] li xichao
none
[3 Jun 12:19] Umesh Shastry
Hello li xichao,

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

regards,
Umesh