Re: [ALUG] mysql users question

On 2004-11-17 21:19:23 +0000 Chris Green <chris@areti.co.uk> wrote:

How do I delete a mysql user?

Either "drop user ..." or "delete from mysql.user where ..." depending on version. See http://dev.mysql.com/doc/mysql/en/Removing_users.html

... and how do I stop a mysql user requiring a password?

Blank the password column in mysql.user, perhaps. Ask yourself: are you sure you want to do that? Remember to "flush privileges;" after editing users. -- MJR/slef My Opinion Only and not of any group I know Creative copyleft computing - http://www.ttllp.co.uk/ Unsolicited attachments to the pipex address deleted Will HLF fund tree-killings? http://www.thewalks.co.uk/