Sure, you can do those with, say, phpMyAdmin, but it’s way quicker to perform such functions using the CLI.
Substitute “db_username”, “db_password”, “db_password” and “db_name” with those of your own.
Add a MySQL Database
From the command line interface, we need first to access the mysql shell:-
And before actually creating the db, you need to set up the database user and password.
Now create the db:-
And exit the MySQL shell:-
Delete a MySQL Database
Easy tiger! From the command line interface, we need first to access mysql:-
And delete the sucker:-
And here’s an alternative way to exit the MySQL shell:-