MYSQLD(8)                                                    MySQL Database System                                                   MYSQLD(8)


       mysqld - the MySQL server


       mysqld [options]


       mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. MySQL Server manages access
       to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information
       such as log files and status files.

       When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those

       The mysqld program has many options that can be specified at startup. For a complete list of options, run this command:

           shell> mysqld --verbose --help

       MySQL Server also has a set of system variables that affect its operation as it runs. System variables can be set at server startup,
       and many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server also has a set of status variables
       that provide information about its operation. You can monitor these status variables to access runtime performance characteristics.

       For a full description of MySQL Server command options, system variables, and status variables, see Section 5.1, “The MySQL Server”.
       For information about installing MySQL and setting up the initial configuration, see Chapter 2, Installing and Upgrading MySQL.


       Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved.

       This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are
       protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use,
       copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any
       form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for
       interoperability, is prohibited.

       The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors,
       please report them to us in writing.

       If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government,
       the following notice is applicable:

       U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government
       customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation
       and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject
       to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of
       the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle
       USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

       This software is developed for general use in a variety of information management applications. It is not developed or intended for use
       in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software
       in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to
       ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of
       this software in dangerous applications.

       Oracle is a registered trademark of Oracle Corporation and/or its affiliates. MySQL is a trademark of Oracle Corporation and/or its
       affiliates, and shall not be used without Oracle's express written authorization. Other names may be trademarks of their respective

       This software and documentation may provide access to or information on content, products, and services from third parties. Oracle
       Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party
       content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred
       due to your access to or use of third-party content, products, or services.

       This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your
       access to and use of this material is subject to the terms and conditions of your Oracle Software License and Service Agreement, which
       has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied,
       reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle or as specifically provided below. This
       document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its
       subsidiaries or affiliates.

       This documentation is NOT distributed under a GPL license. Use of this documentation is subject to the following terms:

       You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as
       the actual content is not altered or edited in any way. You shall not publish or distribute this documentation in any form or on any
       media, except if you distribute the documentation in a manner similar to how Oracle disseminates it (that is, electronically for
       download on a Web site with the software) or on a CD-ROM or similar medium, provided however that the documentation is disseminated
       together with the software on the same medium. Any other use, such as any dissemination of printed copies or use of this documentation,
       in whole or in part, in another publication, requires the prior written consent from an authorized representative of Oracle. Oracle
       and/or its affiliates reserve any and all rights to this documentation not expressly granted above.

       For more information on the terms of this license, or for details on how the MySQL documentation is built and produced, please visit
       MySQL Contact & Questions.

       For additional licensing information, including licenses for third-party libraries used by MySQL products, see Preface and Legal

       For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists where you can discuss your issues with other
       MySQL users.

       For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable
       versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library.


       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available
       online at


       Oracle Corporation (

Hi, Guest!

This is a manual page collection for Linux and Unix-like operating system.


  • Works with all browsers and mobile phones.
  • The HTML in this layout validates as XHTML 1.0 strict.


Search this site