Mysql mysqladmin command

[vasanth]

###Mysql mysqladmin command
===========================

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.

EXAMPLE:
mysqladmin version - (MySQL Client version)
mysqladmin processlist
mysqladmin -u root -p -i 2 processlist
mysqladmin -u user -p -i 5 status
mysqladmin -u user -p -i 5 variables
mysqladmin -u user -p flush-privileges
mysqladmin -u user -p kill xxIDxx


$ mysqladmin create databasename - Create a new database

$ mysqladmin drop databasename - Delete a database and all its tables

$ mysqladmin extended-status - Gives an extended status message from the server

$ mysqladmin ping - Check if mysqld is alive

$ mysqladmin processlist - Show list of active threads in server

$ mysqladmin reload - Reload grant tables

$ mysqladmin shutdown - Take server down

$ mysqladmin status - Gives a short status message from the server

$ mysqladmin variables - Prints variables available

$ mysqladmin version - Get version info from server

To create the database from shell

[root@host]# mysqladmin -u root -p create test1

## MySQL Mysqlshow Command
===========================
mysqlshow - display database, table, and column information.

bash-2.05b# mysqlshow
+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+


Regards,
Vasanth R