On Sun, 17 Mar 2002, Dan Vande More wrote:
> You would have a hard time removing the privileges using GRANT, I would
> suggest using revoke:
> http://www.mysql.com/doc/G/R/GRANT.html
Will it delete user from table mysql.user ?
>
> > >
> >
> But How should I use Grant command to delete user fro
You would have a hard time removing the privileges using GRANT, I would
suggest using revoke:
http://www.mysql.com/doc/G/R/GRANT.html
-Original Message-
From: Marcin Pyla [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: Re: Delete User
> > > So, you can see that I didn't delete him. Why?
> > > What I am doing wrong? How can I delete this user?
> >
> > Why do you want to delete an user by "delete" command from the users table?!
> > For setting or deleteting permissions use GRANT/REVOKE commands
> > instead.
> >
>
But How should
Hello,
I have problem, I can't delete user, this is what I do:
shell> mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 3.22.32
Type 'help' for help.
mys
At 12:54 PM 8/21/01 +0200, Marcin Pyla wrote:
>Hi,
>
>I have problem with delete user:
>
>I login to mysql as root'a and I do:
>
>mysql> delete from user where user='admin80' and Host='%';
>Query OK, 1 row affected (0.07 sec)
Try to escape the '%' character as '\%'
(just a guess, I haven't tri
Hi,
I have problem with delete user:
I login to mysql as root'a and I do:
mysql> select * from user where user='admin80';
+--+-+--+-+-+-+-+-+---+-+---+--+---