Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - What Is "mysqladmin" Command

By: FYIcenter.com

(Continued from previous topic...)

What Is "mysqladmin"?

"mysqladmin" is a command-line interface for administrators to perform server administration tasks. It support a number of commonly used commands like:

  • "mysqladmin shutdown" - Shuts down the server.
  • "mysqladmin ping" - Checks if the server is alive or not.
  • "mysqladmin status" - Displays several important server status values.
  • "mysqladmin version" - Displays version information of the server.
  • "mysqladmin create databaseName" - Creates a new database.
  • "mysqladmin drop databaseName" - Drops an existing database.

(Continued on next topic...)

  1. What Tools Available for Managing MySQL Server?
  2. What Is "mysqld"?
  3. What Is "mysqladmin"?
  4. How To Check Server Status with "mysqladmin"?
  5. How To Shut Down the Server with "mysqladmin"?
  6. What Is "mysql"?
  7. How To Use "mysql" to Run SQL Statements?
  8. How To Show All Tables with "mysql"?
  9. What Is "mysqlcheck"?
  10. How To Analyze Tables with "mysqlcheck"?
  11. What Is "mysqlshow"?
  12. How To Show Table Names with "mysqlshow"?
  13. What Is "mysqldump"?
  14. How To Dump a Table to a File with "mysqldump"?
  15. What Is "mysqlimport"?
  16. How To Load Data Files into Tables with "mysqlimport"?

MySQL Tutorials:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: