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.
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 I use Grant
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
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 from MySQL?
Hi,
I have problem with delete user:
I login to mysql as root'a and I do:
mysql select * from user where user='admin80';
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 tried it)
