mysql_config_editor --login-path = local无法正常工作 [英] mysql_config_editor --login-path=local not working

问题描述

我已经升级到mysql 5.6.13，并认为我会尝试新的--login-path功能.

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

我用"mysql_config_editor set --login-path=local --host=localhost --user=user --password"

在提示符下输入密码后，我看到所有内容都已包含"mysql_config_editor print --all"

After entering the password at the prompt I see that all is there with "mysql_config_editor print --all"

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

如果像这样将"-p"添加到末尾"mysql_config_editor --login-path=local -p"，系统会提示我输入密码，密码会成功连接...呵呵！

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!?

推荐答案

当mysql_config_editor提示您时，在密码周围使用双引号.登录后，特殊字符(例如#)将被识别为密码的一部分.

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.

这篇关于mysql_config_editor --login-path = local无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！