MySQL未在cmd中连接 [英] MySQL not connecting in cmd

问题描述

在尝试 mysql -u user -p 命令时，我不断收到错误 1045(28000).相同的密码在 MySQL 命令行客户端中有效，服务器根据 Workbench 和 Notifier 运行.不确定这是否相关，但唯一奇怪的是 Notifier 显示我有两个东西在运行，两个东西都命名为MySQL56_1"，当我尝试停止一个我没有配置实例"选项的东西时，或者打开SQL 编辑器"，我收到错误消息，说它在 Windows 服务中找不到".

I keep getting the error 1045(28000) when trying the mysql -u user -p command. The same password works in the MySQL Command Line Client and the server is running according to Workbench and Notifier. Not sure if this is related, but the only odd thing is that Notifier shows that I have two things running, both named "MySQL56_1" and when I try to stop the one where I don't have the option to "Configure Instance" or open the "SQL Editor", I get the error saying that it was "not found in the Windows Services".

仍然没有解决这个问题，这里提到的所有命令都会产生错误 1045，其中提到了 'user'@'localhost' 或 'ODBC'@'localhost'

still have not solved this, all of the commands mentioned here yield error 1045 with the variations of mentioning either 'user'@'localhost' or 'ODBC'@'localhost'

推荐答案

好的，如果有人感兴趣，这里对我有用.在 Workbench 的左下角，将列出所有这些模式"，单击任何一个(至少在我的情况下它们都显示相同的参数)，然后使用信息>会话下指定的所有相关参数，使用本章中列出的命令.基本上，用户 Aman Aggarwal 正在谈论什么，我花了一些时间才了解这种交叉检查是如何准确完成的.

Ok, if anyone is interested, here what worked for me. In Workbench, on the bottom left hand corner, there will be all these "schemas" listed, click on any one (they all show the same parameters in my case at least) and, using all the relevant parameters specified under Information>Session, play around with the commands listed in this chapter . Basically what user Aman Aggarwal was talking about, just took me a while to understand how this cross checking is done exactly.

这篇关于MySQL未在cmd中连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！