mysqld - The MySQL Server Program

A quick introduction is provided on the MySQL server daemon program, 'mysqld'. If MySQL service is installed as a Windows service, there is no need to run 'mysqld' directly.

What Is mysqld? mysqld is the MySQL server daemon program. The syntax to run mysqld is:

C:\herong>set "MySQL=\Program Files\MySQL\MySQL Server 5.7"
C:\herong>"%MySQL%\bin\mysqld" [OPTIONS]

mysqld version 5.7 supports a huge list of options. You can get a list of supported options by running this command:

C:\herong>"%MySQL%\bin\mysqld" --help --verbose

\Program Files\MySQL\MySQL Server 5.7\bin\mysqld  
Ver 5.7.10 for Win32 on AMD64 (MySQL Community Server (GPL))
Copyright (c) 2000, 2015, Oracle and/or its affiliates. 
All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Starts the MySQL database server.

Usage: \Program Files\MySQL\MySQL Server 5.7\bin\mysqld [OPTIONS]
NT and Win32 specific options:
                Install the default service (NT).
                Install the default service started manually (NT).
  --install service_name        
                Install an optional service (NT).
  --install-manual service_name 
                Install an optional service started manually (NT).
                Remove the default service from the service list (NT).
  --remove service_name         
                Remove the service_name from the service list (NT).
                Only to be used for the default server (NT).
                Dummy option to start as a standalone server (NT).

Default options are read from the following files in the given order:
C:\Windows\my.cnf C:\my.ini 
C:\my.cnf C:\Program Files\MySQL\MySQL Server 5.7\my.ini 
C:\Program Files\MySQL\MySQL Server 5.7\my.cnf 
The following groups are read: mysqld server mysqld-5.7
The following options may be given as the first argument:
--print-defaults     Print the program argument list and exit.
--no-defaults        Don't read default options from any option file,
                     except for login file.
--defaults-file=#    Only read default options from the given file #.
--defaults-extra-file=# Read this file after global files are read.
                     Also read groups with concat(group, suffix)
--login-path=#       Read this path from the login file.

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}   Value (after reading options)
---------------------------------- -------------
abort-slave-event-count            0
allow-suspicious-udfs              FALSE
archive                            ON
auto-increment-increment           1
auto-increment-offset              1
autocommit                         TRUE
automatic-sp-privileges            TRUE
avoid-temporal-upgrade             FALSE
back-log                           80
basedir                       C:\Program Files\MySQL\MySQL Server 5.7\
To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.

Since MySQL 5.7.10 server is installed as Windows service, there is no need to run "mysqld" program directly now.

Last update: 2015.

Table of Contents

 About This Book

 Introduction of SQL

 MySQL Introduction and Installation

Introduction of MySQL Programs

 List of MySQL Programs

mysqld - The MySQL Server Program

 mysqladmin - The Client Tool for Administrators

 mysql - The Client Tool for End Users

 Using mysql to Run SQL Statements

 mysqldump - Dumping Data to Files

 mysqlimport - Loading Data from Files

 Perl Programs and MySQL Servers

 PHP Programs and MySQL Servers

 Java Programs and MySQL Servers

 Datatypes and Data Literals

 Operations and Expressions

 Character Strings and Bit Strings

 Commonly Used Functions

 Table Column Types for Different Types of Values

 Using DDL to Create Tables and Indexes

 Using DML to Insert, Update and Delete Records

 Using SELECT to Query Database

 Transaction Management and Isolation Levels

 Locks Used in MySQL

 Defining and Calling Stored Procedures

 Variables, Loops and Cursors Used in Stored Procedures

 Outdated Tutorials


 PDF Printing Version