MYSQL + Win32 =困难 [英] MYSQL + Win32 = Difficulties

问题描述

你好，


我是MySQL的新手。我已经在Windows上安装了它，并为root用户分配了一个

密码。现在当我登录时，我执行以下操作：


C：\ mysql \bin> mysql -u root -p

输入密码：** ***


但我得到的是：


错误1045：用户拒绝访问：''root @ localhost''（使用密码：

是）


我似乎找不到为什么我要解决这个问题的答案。可以

有人请解释一下吗？


非常感谢提前。

Hello,

I''ve a newbie to MySQL. I''ve installed it on Windows and assigned a
password to the root user. Now when I log in I do the following:

C:\mysql\bin>mysql -u root -p
Enter password: *****

But all I get is:

ERROR 1045: Access denied for user: ''root@localhost'' (Using password:
YES)

I can''t seem to find an answer as to why i''m hitting this problem. Can
someone please explain?

Many thanks in advance.

推荐答案

Obi Wan Shinobi写道：

Obi Wan Shinobi wrote:

我是MySQL的新手。我已经在Windows上安装了它，并为root用户分配了一个
密码。现在，当我登录时，我执行以下操作：


您是如何分配的？新手常见的问题是他们认为他们分配了一个密码，但他们实际上并没有这么做。

C：\ mysql \ bin> mysql - u root -p
输入密码：*****

I''ve a newbie to MySQL. I''ve installed it on Windows and assigned a
password to the root user. Now when I log in I do the following:
How did you assign it? It is common problem for newbies that they think
they assigned a password but they haven''t actually done it.
C:\mysql\bin>mysql -u root -p
Enter password: *****

如果你尝试会怎么样：

C：\ mysql \bin> mysql -u root


如果你这样做，就意味着没有为root设置密码。

如果失败另外，这意味着为root用户设置了密码，

但您似乎无法正确输入密码。在这种情况下，您需要

重置root密码并重新设置。

What happens if you try:
C:\mysql\bin>mysql -u root

If you get in that way, it means that there is no password set for root.
If that fails also, it means that there is password set for root user,
but you seem to fail to type it correctly. In that case you need to
reset the root password and set it again.

Obi Wan Shinobi写道：

Obi Wan Shinobi wrote:

我是MySQL的新手。我已经在Windows上安装了它，并为root用户分配了一个
密码。现在，当我登录时，我执行以下操作：


您是如何分配的？新手常见的问题是他们认为他们分配了一个密码，但他们实际上并没有这么做。

C：\ mysql \ bin> mysql - u root -p
输入密码：*****

I''ve a newbie to MySQL. I''ve installed it on Windows and assigned a
password to the root user. Now when I log in I do the following:
How did you assign it? It is common problem for newbies that they think
they assigned a password but they haven''t actually done it.
C:\mysql\bin>mysql -u root -p
Enter password: *****

如果你尝试会怎么样：

C：\ mysql \bin> mysql -u root


如果你这样做，就意味着没有为root设置密码。

如果失败另外，这意味着为root用户设置了密码，

但您似乎无法正确输入密码。在这种情况下，您需要

重置root密码并重新设置。

What happens if you try:
C:\mysql\bin>mysql -u root

If you get in that way, it means that there is no password set for root.
If that fails also, it means that there is password set for root user,
but you seem to fail to type it correctly. In that case you need to
reset the root password and set it again.

Obi Wan Shinobi写道：

Obi Wan Shinobi wrote:

我是MySQL的新手。我已经在Windows上安装了它，并为root用户分配了一个
密码。现在，当我登录时，我执行以下操作：


您是如何分配的？新手常见的问题是他们认为他们分配了一个密码，但他们实际上并没有这么做。

C：\ mysql \ bin> mysql - u root -p
输入密码：*****

I''ve a newbie to MySQL. I''ve installed it on Windows and assigned a
password to the root user. Now when I log in I do the following:
How did you assign it? It is common problem for newbies that they think
they assigned a password but they haven''t actually done it.
C:\mysql\bin>mysql -u root -p
Enter password: *****

如果你尝试会怎么样：

C：\ mysql \bin> mysql -u root


如果你这样做，就意味着没有为root设置密码。

如果失败另外，这意味着为root用户设置了密码，

但您似乎无法正确输入密码。在这种情况下，您需要

重置root密码并重新设置。

What happens if you try:
C:\mysql\bin>mysql -u root

If you get in that way, it means that there is no password set for root.
If that fails also, it means that there is password set for root user,
but you seem to fail to type it correctly. In that case you need to
reset the root password and set it again.

这篇关于MYSQL + Win32 =困难的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！