Mysql server comes with a very handy command line utility called mysqladmin. It can be used to perform basic server administration tasks easily. Basic format of using mysqladmin is :

command specifies the administration task that mysqladmin has to perform. Following is the list of important commands mysqladmin supports :

1) create db_name

Create command can be used for creating a new database. The user specified must have the proper privileges to be able to create the new database, otherwise the command will fail. Example :

the command given above prompts for the password for test-user and after reading the password, it connects to mysql server as test-user. After successful login, it will try to create a new db named test-db.

I'll discuss more commands in my next post.