为什么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屋!