mysqladmin

mysql

How can we shutdown mysql server using the mysqladmin utility?

mysqladmin -u root -p shutdown

How can we display the version of MySQL that we are using via the mysqladmin utility?

mysqladmin version

How can we display variables using the mysqladmin utility?

mysqladmin variables

How can we change the root's password using the mysqladmin utility?

We can use the password command that is part of the mysqladmin utility to change the root's password:

mysqladmin -u root -p password "new password"

How can we create an empty database using the mysqladmin utility?

mysqladmin -h host -u root -pmypass create dbName

What is the purpose of the 'mysqladmin reload' command?

NOT SURE.

How can we view the currently executing queries using the mysqladmin utility?

mysqladmin processlist;