Michael, mysql>> DELETE FROM user WHERE Host='localhost' AND User=''; mysql>> QUIT C:\>> C:\mysql\bin\mysqladmin reload
> In my example, you will see that I did DELETE FROM user to remove all rows > where username is blank. However, I did not reload the service. When I did, > it now looks like the correct behavior is happening. Just to make that clear: If you delete users from the grant tables, this will remove the entries, but it will not take effect until you tell the server to reload the grant tables. (The server loads a copy of the grant tables into memory at startup, to speed up lookups.) You can accomplish the reload as you did above, but a more convenient way would be: mysql> DELETE FROM user WHERE Host='localhost' AND User=''; mysql> FLUSH PRIVILEGES; Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] --------------------------------------------------------------------- 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
