Hi,
I have problem with delete user:
I login to mysql as root'a and I do:
mysql> select * from user where user='admin80';
+------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| % | admin80 | 63fd02f86defdc20 | N | N | N
| N | N | N | N | N
| N | N | N | N | N
| N |
+------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
1 row in set (0.03 sec)
mysql> delete from user where user='admin80' and Host='%';
Query OK, 1 row affected (0.07 sec)
mysql> select * from user where user='admin80';
+------+---------+------------------+-------------+-------------+-------------+------$
| Host | User | Password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+------+---------+------------------+-------------+-------------+-------------+------$
| % | admin80 | 63fd02f86defdc20 | N | N | N
| N | N | N | N | N
| N | N | N | N | N
| N |
+------+---------+------------------+-------------+-------------+-------------+------$
1 row in set (0.03 sec)
What is wrong ?
Marcin Pyla
(o_ [ Marcin Pyla - Cubbi <[EMAIL PROTECTED]> | <<+ NetArt ISP +>> ]
(/)_ [ The system is going down to maintenance mode NOW !! ]
---------------------------------------------------------------------
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
