Hi All,
I need to delete around 30 users from multiple databases. I was hoping someone with experience writing scripts might be able to come up with something to speed up the process of deleting 1 user at a time. This is the command I use to delete a user. First I do this command:

mysql -u root -p datbase_name (enter)

I have to enter a mysql password.
Then I delete the user with this command:

delete from user where user='username'; (enter)

I would like to be able to paste a list of usernames in the script so it will go through the delete user line one at a time till the list is done.
If you need more information please let me know.

Thanks,
Nazs

You don't need a script as much as the right bit of SQL.

You'd still have to do some typing, but less than if you did it one line at a time.

If you have a flat file of usernames, you might be able to do something with perl or python (those would be my choices).