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.
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT Host,User,Password FROM user WHERE User = 'admin67';
+------+---------+------------------+
| Host | User | Password |
+------+---------+------------------+
| % | admin67 | 31cb8bb344454eb1 |
+------+---------+------------------+
1 row in set (0.00 sec)
So user 'admin67' exist. Now I'm trying to delete him:
mysql> DELETE FROM user WHERE User = 'admin67' and Host = '%';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT Host,User,Password FROM user WHERE User = 'admin67';
+------+---------+------------------+
| Host | User | Password |
+------+---------+------------------+
| % | admin67 | 31cb8bb344454eb1 |
+------+---------+------------------+
1 row in set (0.00 sec)
So, you can see that I didn't delete him. Why?
What I am doing wrong? How can I delete this user?
--
Pozdrawiam,
Marcin Pyla
(o_ [ <@ Marcin Pyla - Cubbi <[EMAIL PROTECTED]> | <<+ NetArt ISP +>> @> ]
(/)_ [ NT == No Thanks ]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
