为什么Grant命令失败？ [英] Why does Grant command fail?
问题描述
我发出了mysql命令
将所有*。*授予myid @ localhost，标识为mypw;
和收到错误消息
ERROR 1045：拒绝用户访问 ''@ localhost''（使用密码：NO）
我在我自己的机器上运行mysql但没有联网。
什么我做错了，我该如何解决？
我猜这个myid和/或mypw可能是错的。如果是这样，我如何找到
的正确值应该是什么？
谢谢....
Bruce A. Julseth
一个名叫bruceaj的horsie表现出令人惊讶的智能和它的b / b
使用摩尔斯电码的能力太阳，2003年9月7日09:22:25 -0500当它是b / b
tapped< 3f ******** @ news1.prserv.net>用它的蹄：
我发出了mysql命令
将所有*。*授予myid @ localhost，标识为mypw;
并收到错误消息
错误1045：拒绝用户访问 ''@ localhost''（使用密码：NO）
我在自己的机器上运行mysql，而不是联网。
我做错了什么，我怎么做修复它？
我在猜测myid和/或mypw可能是错的。如果是这样，我该如何找出正确的值应该是什么？
谢谢....
Bruce A. Julseth
您只能授予您拥有的权限，并且由于您匿名登录了
，因此您作为用户运行的几乎是
没有特权。首先以更高权限的用户身份登录。只有
授予您希望该用户名具有的特权。
您真的希望此用户名具有DROP和SHUTDOWN
特权？
我是这台机器的唯一用户。在我的XP启动页面上，我的用户名是
我的名字，我使用无密码。此ID具有管理员权限。
这是您在回复中讨论的用户吗？如果是这样的话，那将是
将*。*全部授予''我的名字''@ localhost标识为????由于我没有使用密码，我在这里放了什么？
？
工作。我试过了，猜猜怎么着？它没用。所以我还是不知道是什么
我正在做什么!!
由于我有XP管理员权限，我是否必须创建用户带有
密码的身份证？
我将尝试这种方法但是，假设它不起作用，我会
感谢您的评论。
谢谢....
布鲁斯
Gary Petersen < GA ******* @ remove.meearthlink.invalid>在消息中写道
news：pa ******************************** @ REMOVE.MEe arthlink.INVALID ...名为bruceaj的horsie表现出令人惊讶的智能及其在Sun，2003年9月7日09:22:25 -0500上使用摩尔斯电码的能力> tapped< 3f ******** @ news1.prserv.net>用它的蹄：
我发出了mysql命令
将所有*。*授予myid @ localhost，标识为mypw;
并收到错误消息
错误1045：拒绝用户访问 ''@ localhost''（使用密码：NO）
我在自己的机器上运行mysql，而不是联网。
我做错了什么，我怎么做修复它？
我在猜测myid和/或mypw可能是错的。如果是这样，我该如何找出正确的值应该是什么？
谢谢....
Bruce A. Julseth
您只能授予您拥有的权限，并且由于您以匿名方式登录，因此您作为几乎没有权限的用户运行。首先以更高权限的用户身份登录。只有
授予您希望该用户名具有的权限。
您真的希望此用户名具有DROP和SHUTDOWN
权限吗？
好。我在我的XP机器上创建了一个带密码的新用户，并在mysql下发出了
以下命令，
将所有*。*全部授予newuser @ localhost标识为newpw;
并得到相同的错误，ERROR 1045：拒绝用户访问 ''@ localhost''
（使用密码：否）
< br ***** @ attglobal.net>在留言新闻中写道：3f ******** @ news1.prserv.net ...我是这台机器的唯一用户。我的用户名，在我的XP启动页面上，是我的名字，我没有使用密码。此ID具有管理员权限。
这是您在回复中讨论的用户吗？如果是这样的话，将
全部放在*。*上以''我的名字''@ localhost标识为????因为我没有使用密码，所以我在这里放了什么？
工作。我试过了，猜猜怎么着？它没用。所以我还是不知道
我在做什么!!
由于我有XP管理员权限，我是否必须使用
密码创建用户ID ？
我打算尝试这种方法但是，假设它不起作用，我会b / b感谢你的评论。
谢谢。 ......布鲁斯
加里彼得森 < GA ******* @ remove.meearthlink.invalid>在消息中写道
新闻：pa ******************************** @ REMOVE.MEe arthlink.INVALID。 ..名为bruceaj的horsie表现出令人惊讶的聪明才智及其在Sun，2003年9月7日09:22:25 -0500上使用摩尔斯电码的能力，当它点击了< 3f********@news1.prserv.net>用它的蹄：
我发出了mysql命令
将所有*。*授予myid @ localhost，标识为mypw;
并收到错误消息
错误1045：拒绝用户访问 ''@ localhost''（使用密码：NO）
我在自己的机器上运行mysql，而不是联网。
我做错了什么，我怎么做修复它？
我在猜测myid和/或mypw可能是错的。如果是这样，
我怎么知道正确的值应该是什么？
谢谢....
Bruce A. Julseth
您只能授予您拥有的权限，并且由于您以匿名方式登录，因此您作为几乎没有权限的用户运行。首先以更高权限的用户身份登录。只有
授予您希望该用户名具有的权限。
您真的希望此用户名具有DROP和SHUTDOWN
权限吗？
I issued the mysql command
Grant all on *.* to myid@localhost identified as "mypw";
and recieved the error message
ERROR 1045: Access denied for user" ''@localhost'' (Using password: NO)
I am running mysql on my own machine which is not networked.
What am I doing wrong and how do I fix it?
I am guessing that "myid" and/or "mypw" might be wrong. If so, how do I find
out what the correct values should be?
Thanks....
Bruce A. Julseth
A horsie named bruceaj demonstrated surprising intellligence and its
ability to use morse code on Sun, 07 Sep 2003 09:22:25 -0500 when it
tapped <3f********@news1.prserv.net> with its hoof:
I issued the mysql command
Grant all on *.* to myid@localhost identified as "mypw";
and recieved the error message
ERROR 1045: Access denied for user" ''@localhost'' (Using password: NO)
I am running mysql on my own machine which is not networked.
What am I doing wrong and how do I fix it?
I am guessing that "myid" and/or "mypw" might be wrong. If so, how do I
find out what the correct values should be?
Thanks....
Bruce A. Julseth
You can only grant privileges that you have, and since you
logged in anonymously, you are running as a user with almost
no privileges. Log-in as a more privileged user first. Only
grant priviledges that you want that user-name to have.
Do you really want this user-name to have DROP and SHUTDOWN
privileges?
I''m the only user of this machine. My user name, on my XP startup page, is
my name and I use NO password. This id has admin privileges.
Is this the user you are discussing in your reply? If so, would
Grant all on *.* to ''my name''@localhost identified as ???? What do I put
here since I don''t use a password?
work. I tried it and, guess what? It didn''t work. So I still don''t know what
I''m doing!!
Since I have XP admin privileges, will I have to create a user id with a
password?
I''m going to try that approach but, on the assumption it won''t work, I would
appreciate your comments.
Thanks....
Bruce
"Gary Petersen" <ga*******@remove.meearthlink.invalid> wrote in message
news:pa********************************@REMOVE.MEe arthlink.INVALID...A horsie named bruceaj demonstrated surprising intellligence and its
ability to use morse code on Sun, 07 Sep 2003 09:22:25 -0500 when it
tapped <3f********@news1.prserv.net> with its hoof:I issued the mysql command
Grant all on *.* to myid@localhost identified as "mypw";
and recieved the error message
ERROR 1045: Access denied for user" ''@localhost'' (Using password: NO)
I am running mysql on my own machine which is not networked.
What am I doing wrong and how do I fix it?
I am guessing that "myid" and/or "mypw" might be wrong. If so, how do I
find out what the correct values should be?
Thanks....
Bruce A. Julseth
You can only grant privileges that you have, and since you
logged in anonymously, you are running as a user with almost
no privileges. Log-in as a more privileged user first. Only
grant priviledges that you want that user-name to have.
Do you really want this user-name to have DROP and SHUTDOWN
privileges?
Okay. I created a new user with a password on my XP machine and issued the
following command under mysql,
Grant all on *.* to newuser@localhost identified as "newpw";
and got the same error, ERROR 1045: Access denied for user" ''@localhost''
(Using password: NO)
<br*****@attglobal.net> wrote in message news:3f********@news1.prserv.net...I''m the only user of this machine. My user name, on my XP startup page, is
my name and I use NO password. This id has admin privileges.
Is this the user you are discussing in your reply? If so, would
Grant all on *.* to ''my name''@localhost identified as ???? What do I put here since I don''t use a password?
work. I tried it and, guess what? It didn''t work. So I still don''t know what I''m doing!!
Since I have XP admin privileges, will I have to create a user id with a
password?
I''m going to try that approach but, on the assumption it won''t work, I would appreciate your comments.
Thanks....
Bruce
"Gary Petersen" <ga*******@remove.meearthlink.invalid> wrote in message
news:pa********************************@REMOVE.MEe arthlink.INVALID...A horsie named bruceaj demonstrated surprising intellligence and its
ability to use morse code on Sun, 07 Sep 2003 09:22:25 -0500 when it
tapped <3f********@news1.prserv.net> with its hoof:I issued the mysql command
Grant all on *.* to myid@localhost identified as "mypw";
and recieved the error message
ERROR 1045: Access denied for user" ''@localhost'' (Using password: NO)
I am running mysql on my own machine which is not networked.
What am I doing wrong and how do I fix it?
I am guessing that "myid" and/or "mypw" might be wrong. If so, how do I find out what the correct values should be?
Thanks....
Bruce A. Julseth
You can only grant privileges that you have, and since you
logged in anonymously, you are running as a user with almost
no privileges. Log-in as a more privileged user first. Only
grant priviledges that you want that user-name to have.
Do you really want this user-name to have DROP and SHUTDOWN
privileges?
这篇关于为什么Grant命令失败？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
