mysql_config_editor --login-path=local not working

Question

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

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

After entering the password at the prompt I see that all is there 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" onto the end like so "mysql_config_editor --login-path=local -p" I am prompted to enter the password and it connects successfully...huhhh!?

Answer 1

Use double quotes around the password when mysql_config_editor prompts you. Then special characters (e.g. #) will be recognized as part of the password upon login.

Answer 2

There seems to be a bug somewhere in the mysql commands. If you have a '#'-sign (confirmed) in the password or maybe some other "strange" characters (unconfirmed), the --login-path method doesn't work. Test with another password.