DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) server-side-overview

Info Catalog (mysql.info) database-administration (mysql.info) database-administration (mysql.info) mysqld
 
 5.1 Overview of Server-Side Programs
 ====================================
 
 The MySQL server, `mysqld', is the main program that does most of the
 work in a MySQL installation. The server is accompanied by several
 related scripts that perform setup operations when you install MySQL or
 that assist you in starting and stopping the server. This section
 provides an overview of the server and related programs. The following
 sections provide more detailed information about each of these programs.
 
 Each MySQL program takes many different options. Most programs provide
 a -help option that you can use to get a description of the program's
 different options. For example, try `mysqld --help'.
 
 You can override default option values for MySQL programs by specifying
 options on the command line or in an option file.  
 program-options.
 
 The following list briefly describes the MySQL server and
 server-related programs:
 
    * `mysqld'
 
      The SQL daemon (that is, the MySQL server). To use client
      programs, `mysqld' must be running, because clients gain access to
      databases by connecting to the server.  See  mysqld.
 
    * `mysqld-max'
 
      A version of the server that includes additional features. See
       mysqld-max.
 
    * `mysqld_safe'
 
      A server startup script. `mysqld_safe' attempts to start
      `mysqld-max' if it exists, and `mysqld' otherwise. See 
      mysqld-safe.
 
    * `mysql.server'
 
      A server startup script. This script is used on systems that use
      System V-style run directories containing scripts that start
      system services for particular run levels. It invokes
      `mysqld_safe' to start the MySQL server. See  mysql-server.
 
    * `mysqld_multi'
 
      A server startup script that can start or stop multiple servers
      installed on the system. See  mysqld-multi. As of MySQL
      5.0.3 (Unix-like systems) or 5.0.13 (Windows), an alternative to
      `mysqld_multi' is `mysqlmanager', the MySQL Instance Manager.
      instead of `mysqld_multi'. See  instance-manager.
 
    * `mysql_install_db'
 
      This script creates the MySQL database and initializes the grant
      tables with default privileges. It is usually executed only once,
      when first installing MySQL on a system. See 
      unix-post-installation.
 
    * `mysql_fix_privilege_tables'
 
      This program is used after a MySQL upgrade operation. It updates
      the grant tables with any changes that have been made in newer
      versions of MySQL. See  mysql-fix-privilege-tables.
 
      Note: As of MySQL 5.0.19, this program has been superseded by
      `mysql_upgrade'.
 
    * `mysql_upgrade'
 
      This program is used after a MySQL upgrade operation. It checks
      tables for incompatibilities and repairs them if necessary, and
      updates the grant tables with any changes that have been made in
      newer versions of MySQL. See  mysql-upgrade.
 
    * `mysqlmanager'
 
      The MySQL Instance Manager, a program for monitoring and managing
      MySQL servers. See  instance-manager.
 
 There are several other programs that are run on the server host:
 
    * `make_binary_distribution'
 
      This program makes a binary release of a compiled MySQL. This
      could be sent by FTP to `/pub/mysql/upload/' on `ftp.mysql.com'
      for the convenience of other MySQL users.
 
Info Catalog (mysql.info) database-administration (mysql.info) database-administration (mysql.info) mysqld
automatically generated byinfo2html