Delete User problem.
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
Re: Delete User problem.
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 command to delete user from MySQL? -- Pozdrawiam, Marcin Pyla (o_ [ @ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + @ ] (/)_ [ Nigdy nie ufaj systemowi operacyjnemu, do ktrego ] [ nie masz kodw rdowych. ] - 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
RE: Delete User problem.
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? -- Pozdrawiam, Marcin Pyla (o_ [ @ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + @ ] (/)_ [ Kady programista powie Ci, e lepiej napisa nowy program ] [ ni poprawia cudzy.] - 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
Faster mysql
Hello, How I can make my mysql faster ? Can I compile it with special options ? Pozdrawiam, Marcin Pyla (o_ [ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + ] (/)_ [ God, root, what's the difference? -- God is more forgiving ] - 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
RE: Faster mysql
On Wed, 12 Sep 2001, Simon Green wrote: Look and making MySQL fly The hard stuff is where to start. Raid 0 and lost of memory I used Raid 5 + 1 (hardware) and it gaves only 2 seconds faster... Then yes there are a few things that you can remove when compiling to make things faster depending what you need to do. And then theirs stuff to do in my.cnf Can you give me an exempels ? Simon -Original Message- From: Marcin Pyla [mailto:[EMAIL PROTECTED]] Sent: 12 September 2001 14:19 To: [EMAIL PROTECTED] Subject: Faster mysql Hello, How I can make my mysql faster ? Can I compile it with special options ? Pozdrawiam, Marcin Pyla (o_ [ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + ] (/)_ [ God, root, what's the difference? -- God is more forgiving ] - 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 Pozdrawiam, 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
Delete user problem
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