MYSQLD(1)						      General Commands Manual							 MYSQLD(1)

NAME

       mysqld
	- Starts the MySQL server demon

USAGE

       mysqld [OPTIONS]

SYNOPSIS

       mysqld  [--ansi]  [-b|--basedir=path]  [--big-tables]  [--bind-address=IP]  [--character-sets-dir=path] [--chroot=path] [-h|--datadir=path]
       [--default-character-set=charset]  [--default-table-type=type]	[--delay-key-write-for-all-tables]   [--enable-locking]   [-T|--exit-info]
       [--flush]   [-?|--help]	 [--init-file=file]   [-L|--language=...]    [-l|--log[=file]]	 [--log-isam[=file]]   [--log-slow-queries[=file]]
       [--log-update[=file]] [--log-long-format] [--low-priority-updates] [--memlock] [ --myisam-recover [=option[,option...]]]  where	option	is
       one  of	DEFAULT,  BACKUP,  FORCE  or  QUICK.]	[--pid-file=path]  [-P|--port=...]  [-o|--old-protocol] [--one-thread] [-O|--set-variable-
       var=option]  [-Sg|--skip-grant-tables]  [--safe-mode]  [--secure]  [--skip-concurrent-insert]   [--skip-delay-key-write]   [--skip-locking]
       [--skip-name-resolve]  [--skip-networking] [--skip-new] [--skip-host-cache] [--skip-show-database] [--skip-thread-priority] [--socket=path]
       [-t|--tmpdir=path] [-u|--user=user_name] [-V|--version]

DESCRIPTION

       --ansi Use ANSI SQL syntax instead of MySQL syntax. See section 5.2 Running MySQL in ANSI Mode.

       -b|--basedir=path
	      Path to installation directory. All paths are usually resolved relative to this.

       --big-tables
	      Allow big result sets by saving all temporary sets on file. It solves most 'table full' errors, but  also  slows	down  the  queries
	      where  in-memory tables would suffice. Since Version 3.23.2, MySQL is able to solve it automaticaly by using memory for small tempo-
	      rary tables and switching to disk tables where necessary.

       --bind-address=IP
	      IP address to bind to.

       --character-sets-dir=path
	      Directory where character sets are. See section 10.1.1 The Character Set Used for Data and Sorting.

       --chroot=path
	      Chroot mysqld daemon during startup. Recommended security measure. It will somewhat limit LOAD DATA INFILE and SELECT ... INTO  OUT-
	      FILE though.

       -h|--datadir=path
	      Path to the database root.

       --default-character-set=charset
	      Set the default character set. See section 10.1.1 The Character Set Used for Data and Sorting.

       --default-table-type=type
	      Set the default table type for tables. See section 8 MySQL Table Types.

       --delay-key-write-for-all-tables
	      Don't flush key buffers between writes for any MyISAM table. See Mysql Manual section 12.2.3 Tuning Server Parameters.

       --enable-locking
	      Enable system locking.

       -T|--exit-info
	      Print some debug info at exit.

       --flush
	      Flush all changes to disk after each SQL command. Normally MySQL only does a write of all changes to disk after each SQL command and
	      lets the operating system handle the syncing to disk. See section 20.2 What to Do if MySQL Keeps Crashing.

       -?|--help
	      Display short help and exit.

       --init-file=file
	      Read SQL commands from this file at startup.

       -L|--language=...
	      Client error messages in given language. May be given as a full path. See Mysql Manual section 10.1 What Languages Are Supported	by
	      MySQL?.

       -l|--log[=file]
	      Log connections and queries to file.

       --log-isam[=file]
	      Log all ISAM/MyISAM changes to file (only used when debugging ISAM/MyISAM).

       --log-slow-queries[=file]
	      Log  all	queries that have taken more than long_query_time seconds to execute to file. See Mysql Manual section 21.5 The Slow Query
	      Log.

       --log-update[=file]
	      Log updates to file.# where # is a unique number if not given. See Mysql Manual section 21.3 The Update Log.

       --log-long-format
	      Log some extra information to update log. If you are using --log-slow-queries then queries that are not using indexes are logged	to
	      the slow query log.

       --low-priority-updates
	      Table-modifying operations (INSERT/DELETE/UPDATE) will have lower priority than selects. It can also be done via {INSERT | REPLACE |
	      UPDATE | DELETE} LOW_PRIORITY ... to lower the priority of only one query, or by SET OPTION SQL_LOW_PRIORITY_UPDATES=1 to change the
	      priority in one thread. See Mysql Manual section	12.2.9 Table Locking Issues.

       --memlock
	      Lock  the  mysqld process in memory. This works only if your system supports the mlockall() system call. This may help if you have a
	      problem where the operating system is causing mysqld to swap on disk.

	--myisam-recover [=option[,option...]]] where option is one of DEFAULT, BACKUP, FORCE or QUICK.
	      If this option is used, mysqld will on open check if the table is marked as crashed or if if the table wasn't closed  properly  (The
	      last option only works if you are running with --skip-locking). If this is the case mysqld will run check on the table. If the table
	      was corrupted, mysqld will attempt to repair it. The following options affects how the repair works.  DEFAULT The same as not giving
	      any  option  to  --myisam-recover.   BACKUP If the data table was changed during recover, save a backup of the `table_name.MYD' data
	      file as `table_name-datetime.BAK'.  FORCE Run recover even if we will loose more than one row from the .MYD file.  QUICK Don't check
	      the  rows  in the table if there isn't any delete blocks.  Before a table is automaticly repaired, mysqld will add a note about this
	      in the error log. If you want to be able to recover from	most  things  without  user  intervention,  you  should  use  the  options
	      BACKUP,FORCE. This will force a repair of a table even if some rows would be deleted, but it will keep the old data file as a backup
	      so that you can later examine what happened.

       --pid-file=path
	      Path to pid file used by safe_mysqld.

       -P|--port=...
	      Port number to listen for TCP/IP connections.

       -o|--old-protocol
	      Use the 3.20 protocol for compatibility with some very old clients. See Mysql Manual section  4.17.3 Upgrading from Version 3.20	to
	      Version 3.21.

       --one-thread
	      Only use one thread (for debugging under Linux). See Mysql Manual section  H.1 Debugging a MySQL server.

       -O| --set-variable var=option
	      Give  a variable a value. --help lists variables. You can find a full description for all variables in the SHOW VARIABLES section in
	      this manual. See Mysql Manual section  7.28.4 SHOW VARIABLES. The tuning server parameters section includes information  of  how	to
	      optimize these. See Mysql Manual section	12.2.3 Tuning Server Parameters.

       -Sg|--skip-grant-tables
	      This  option  causes  the  server not to use the privilege system at all. This gives everyone full access to all databases! (You can
	      tell a running server to start using the grant tables again by executing mysqladmin flush-privileges or mysqladmin reload.)

       --safe-mode
	      Skip some optimize stages. Implies --skip-delay-key-write.

       --secure
	      IP numbers returned by the gethostbyname() system call are checked to make sure they resolve back to  the  original  hostname.  This
	      makes  it harder for someone on the outside to get access by pretending to be another host. This option also adds some sanity checks
	      of hostnames. The option is turned off by default in MySQL Version 3.21 because sometimes it takes a long time to  perform  backward
	      resolutions. MySQL Version 3.22 caches hostnames (unless --skip-host-cache is used) and has this option enabled by default.

       --skip-concurrent-insert
	      Turn  off the ability to select and insert at the same time on MyISAM tables. (This is only to be used if you think you have found a
	      bug in this feature).

       --skip-delay-key-write
	      Ignore the delay_key_write option for all tables. See Mysql Manual section  12.2.3 Tuning Server Parameters.

       --skip-locking
	      Don't use system locking. To use isamchk or myisamchk you must shut down the server. See Mysql Manual section   1.6  How	Stable	Is
	      MySQL?. Note that in MySQL Version 3.23 you can use REPAIR and CHECK to repair/check MyISAM tables.

       --skip-name-resolve
	      Hostnames are not resolved. All Host column values in the grant tables must be IP numbers or localhost.

       --skip-networking
	      Don't  listen for TCP/IP connections at all. All interaction with mysqld must be made via Unix sockets. This option is highly recom-
	      mended for systems where only local requests are allowed. However, this option is unsuitable  for  systems  that	use  MIT-pthreads,
	      because the MIT-pthreads package doesn't support Unix sockets.

       --skip-new
	      Don't use new, possible wrong routines. Implies --skip-delay-key-write

       --skip-host-cache
	      Never use host name cache for faster name-ip resolution, but query DNS server on every connect instead.

       --skip-show-database
	      Don't allow 'SHOW DATABASE' commands, unless the user has process privilege.

       --skip-thread-priority
	      Disable using thread priorities for faster response time.

       --socket=path
	      Socket file to use for local connections instead of default /tmp/mysql.sock.

       -t|--tmpdir=path
	      Path for temporary files. It may be useful if your default /tmp directory resides on a partition too small to hold temporary tables.

       -u|--user=user_name
	      Run mysqld daemon as user user_name. This option is mandatory when starting mysqld as root.

       -V|--version
	      Output version information and exit.

NOTE

SEE ALSO

       isamchk	(1),  isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
       (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR

       Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).	This software  comes  with
       no  warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mer-
       curmedia.com)

								 19 December 2000							 MYSQLD(1)