D
dman_2007
Guest
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.
mysqladmin [options] command [command-options] [command [command-options]] ...
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 :
mysqladmin -u test-user -p create test-db
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.