mysqladmin Command in MySQL

mysqladmin - is a utility provided by MySQL to perform admin tasks from command line.


syntax:
# mysqladmin -h hostname -u username -p <Commands>

 user will be prompted for password.

example:
# mysqladmin -h localhost -u root -p Create College
this will create college database


# mysqladmin -h localhost -u root -p drop College
this will delete existing college database


Note:
# --> shell prompt
C:\>  Command prompt


# mysqladmin -h localhost -u root status
 return status information from the server


# mysqladmin -h localhost -u root ping
checks MySQL server is available or not