Yes it will revoke those privileges, but only after you issue a "flush privileges".
Generally speaking, It's a good idea to get rid of those "blank" entries anyway... Just make sure your apps aren't connecting to the DB with those "blank uname & passwd" privs first.. Cheers, Andrew -----Original Message----- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Thursday 27 March 2003 18:46 To: [EMAIL PROTECTED] Subject: Revoking Privs I am trying to clear up our msyql by revoking privileges for users who no longer exist on a particular server. If I delete the users in the appropriate tables in the mysql database, will that revoke their privileges? I found in the user table in the mysql a few 'users' with no username or password (the fields are completely blank) under generic hosts (localhost, etc). Should I delete these? Thanks, -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
