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

查看:258

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

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

配置

在提示符下输入密码后,我看到所有内容都已包含"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",系统会提示我输入密码,密码会成功连接...呵呵!

解决方案

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

  • 原文

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

解决方案

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.