Robert Oschler wrote:
I'm running MySQL 4.0 on SuSE Linux 7.3 Pro. I accidentally granted
priveledges to a user with the following user label, quotes are part of the
user label:
// NOTE: replace [at] with @, this was done to keep the mail client from
turning it into a "mailto:" link.
"someuser[at]180.150.2.%"
I did this by enclosing the entire user label in quotes rather that just the
ip
address portion of the user label. That is, it should have been:
someuser[at]"180.150.2.%"
When I do a mysqldump I see a user table entry as follow:
INSERT INTO user VALUES('%', 'someuser[at]180.150.2.%',.....
No matter what syntax I use for REVOKE, I can't get rid of this entry:
What can I do?
thx
--
Robert Oschler
"Let the web hear you, add your voice to your web site in minutes!"
-- http://audiodirect.spiderchase.com/
(For a limited time, free voiceover with every sign-up, use this link
instead)
-- http://audio.spiderchase.com/
I'm using Redhat 8.0 and MySQL 4.0.7-gamma-Max this is how I'd tackle
it.It may or maynot work for your version but it's worth a try. Take a
look at the user table
use mysql;
SELECT Host, User, Password
FROM user;
This should show you your users then *carefully* remove the spurious
user - try doing a select on the user first just to make sure your
`where` clause is correct.
SELECT Host, User, Password FROM user WHERE User=<your user in quotes>;
See what is actually entered into the table for that user - I added your
user and the field was truncated to 'someuser[at]180.' so I'm not sure
where the rest of your ip came from in the insert statement on the
backup. Doesn't matter just remove the entry with the unwanted user
....
DELETE FROM user WHERE User=<your user in quotes.>
...now flush privilegs.. always a good idea when messing with users & access
FLUSH PRIVILEGES;
....then...
SELECT Host, User, Password
FROM user;
again and see it's gone, hopefully.;)
lol
Chris