If you want to delete the database itself, then the DROP DATABASE command will delete the complete database along with all of the tables inside it.
Now, we will create the script mysql_14.sh to drop the database:
#!/bin/bash mysql -u user1 -pTest623@! <<MY_QUERY DROP DATABASE testdb; MY_QUERY
Now, save the program and run it as follows:
$ chmod +x mysql_14.sh $ ./mysql_14.sh
After executing this script, your database will have been deleted. To check this, run this same script again, and you will get the following error message:
ERROR 1008 (HY000) at line 2: Can't drop database 'testdb'; database doesn't exist