Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - What Is "mysqld" Command

By: FYIcenter.com

(Continued from previous topic...)

What Is "mysqld"?

"mysqld" is MySQL server daemon program which runs quietly in background on your computer system. Invoking "mysqld" will start the MySQL server on your system. Terminating "mysqld" will shutdown the MySQL server. Here is a tutorial example of invoking "mysqld" with the "--console" option:

>cd \mysql\bin
>mysqld --console
... 21:52:54  InnoDB: Started; log sequence number 0 43655
... 21:52:54 [Note] mysqld: ready for connections.
Version: '5.0.24-community'  socket: ''  port: 3306  
 MySQL Community Edition (GPL)

The returning message indicates that "mysqld" running now, and your MySQL server is ready to take client connections. To know about "mysqld", read other parts of this FAQ collection.

(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: