Thread: Delete MySQL User Shell Script

Good Morning,

sorry for my frequently question, but how I can delete an sql users from shell scripts in an one command?

THanks for the support

There is no need to write a shell script. All you have to do is run one command at mysql> prompt:

Code:

DROP USER userName;

However, DROP USER will not automatically delete any database objects that the user created. This applies to tables, views, stored routines, and triggers etc all.

yes but i want insert the command into bash scripts because it is an part of an multiple operation

if i want make this into only line i can use this?

Code:

mysql -uroot -ppassword > DROP USER users;

I have tryed but it seems not work... where i wrong?

Try

Code:

#!/bin/bash
...
...
# set username
userName="foo"
mysql -u username -p'Password' -e "DROP USER $userName;"
...
..

Hi,

i have tryed but this is the error

Code:

ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'foo'@'%'

You need to set userName varaible with actual username. If you want to delete a user called vivek, it must be set to vivek:

Code:

 userName="vivek"

Also, you need to specify @localhost i.e.:

Code:

 mysql -u username -p'Password' -e "DROP USER $userName@localhost;"

To view grants see:

Code:

mysql -u root -p'password' mysql -e "SHOW GRANTS for $userName@localhost;"

HTH

you are the best it work

thanks