How to create mysql database, using mysqladmin

By | February 1, 2014

What is MySQLAdmin?

mysqladmin is a client for performing administrative operations. You can use it to check the server’s configuration and current status, to create and drop databases, and more.

Howto?

gen@en-01# mysqladmin -u sibanda -p create sibdb

Enter password:

It is recommended that If you create a new database it’s good to create user with permissions only for the database you are creating (if anything goes wrong you won’t compromise root user login and password).

Hope you find this helpful.