I did some experimenting and here is what I found:
grant all
-> on *
-> to bugsbunny indentified by 'bugs
-> with grant option;
After putting the above into MySQL as root, I signed on as "todd" with
the appropriate PW and tried to get into mysql with
mysql -u bugsbunny -p [using bugs as the PW]. I was refused
[EMAIL PROTECTED] is refused. I noticed that all of the
privileges were set to "N".
Then I tried
grant all
-> on *.*
-> to bugsbunny indentified by 'bugs'
-> with grant option;
I was refused again with the same message however all of the privileges
were set to "Y".
Lastly, I tried
-> on *.*
-> to [EMAIL PROTECTED] indentified by 'bugs'
-> with grant option;
I was able to gain access and all of the privileges were set to "Y".
The "%" in the Host column does not appear to work for me, and there is
something different about "*" and "*.*".
Todd
Nils Valentin wrote:
Hi Todd,
2003年 8月 4日 月曜日 08:01、Todd Cary さんは書きました:
Nils -
What is the difference between "*.* " and "* "?
Hi Todd I just double checked.
There is no difference. Both work the same way. I originally thought that the
first one wouldn't have worked, but I checked it now. However I believe that
*.* is the prober syntax.
Does Grant All give the user the rights to create a DB?
The below command allows the user todd all privileges (CREATE,INSERT,DELETE,
UPDATE etc.) . The "with grant option" will also allow the user todd to
create new users.
About the command itself, I just doule checked once more.
If you specify only the username then a wildcard is insert for the hostname
(%) which allows the user todd to be able to login from anywhere. make sure
thats what you really want !!
In any other case you could specify the user as '[EMAIL PROTECTED]' to limit it to
only the one host.
Best regards
Nils Valentin
Tokyo/Japan
Many thanks....
Todd
Nils Valentin wrote:
Hi Todd,
try this
grant all
-> on *.*
-> to todd indentified by 'my_password'
-> with grant option;
I believe you forgot the ".* " wich I added after grant all on...
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月 4日 月曜日 01:52、Todd Cary さんは書きました:
I have installed Red Hat 9 and it installs MySQL. After logging on as
root, I did the following:
mysql
mysql> use mysql;
mysql> grant all
-> on *
-> to todd indentified by 'my_password'
-> with grant option;
I then log out of mysql and log out as root. Logged in as "todd" I type
the following:
mysql -u todd -p
I type in my password and I get the following error:
Acess denied for [EMAIL PROTECTED]
When I was in mysql as root, "select * from user" has "todd" listed.
What have I missed?
Todd
--
![]() |
<<inline: NewLogo.gif>>
