2)
drop db_name
This command is used for deleting an existing database. Again, the user specified must have the proper privileges to be able to delete the database, otherwise the command will fail. Example :
Quote:
|
mysqladmin -u test-user -p drop test-db
|
3)
flush-privileges
This command is same as reload command. It can be used for reloading privilege grant tables. Example,
Quote:
|
mysqladmin -u root -p flush-privileges
|
4)
password new-password
password command is used for changing the password of the user you use to connect to mysql server. EXample,
Quote:
|
mysqladmin -u root -p password 'sample-password'
|
5)
ping
pings to check whether the server is working or not. Example,
Quote:
|
mysqladmin -u test-user ping
|
6)
reload
This command reloads the privilege grant tables. Example,
Quote:
|
mysqladmin -u root -p reload
|
7)
shutdown
stops mysql server. Example,
Quote:
|
mysqladmin -u root -p shutdown
|
8)
status
This command when used displays mysql server status. Example,
Quote:
|
mysqladmin -u test-user status
|
9)
variables
This command is used for displaying server system variables and their values. Example,
Quote:
|
mysqladmin -u test-user variables
|