236

Appendix B     Getting Started with MySQL

  flush tables          Flush all tables

  flush threads         Flush the thread cache

  flush privileges      Reload grant tables (same as reload)

  kill id,id,...

Kill mysql threads

  password new password Change old password to new password

  ping

Check if mysqld is alive

  processlist

Show list of active threads in server

  reload

Reload grant tables

  refresh

Flush all tables and close and open logfiles

  shutdown

Take server down

  status

Gives a short status message from the server

  start slave

Start slave

  stop slave

Stop slave

  variables             Prints variables available

  version

Get version info from server

[root@conformix]#

You can use different options on the command line. For example  mysqladmin

version  will show the version number for the utility.