Mysql_config_editor --login-path = local not working

Question

I upgraded to mysql 5.6.13 and thought I would try the new -login-path function.

I configure using "mysql_config_editor set --login-path=local --host=localhost --user=user --password"

After entering the password in the prompt, I see that everything is with "mysql_config_editor print --all"

When I do "mysql_config_editor --login-path=local" I **always** get "ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES)"

If I add "-p" to the end, for example, "mysql_config_editor --login-path=local -p" , I will be asked to enter a password and it will be connected successfully ... huhhh !?

Answer 1

Use double quotation marks around the password when querying mysql_config_editor. Then special characters (for example, #) will be recognized as part of the password at login.

Answer 2

There seems to be something wrong with mysql commands. If you have a “#” sign (confirmed) in the password, or perhaps some other “strange” characters (unconfirmed), the -login-path method does not work. Verify a different password.