Welcome to Linux Knowledge Base and Tutorial
"The place where you learn linux"
The ONE Campaign to make poverty history

 Create an AccountHome | Submit News | Your Account  

Tutorial Menu
Linux Tutorial Home
Table of Contents

· Introduction to Operating Systems
· Linux Basics
· Working with the System
· Shells and Utilities
· Editing Files
· Basic Administration
· The Operating System
· The X Windowing System
· The Computer Itself
· Networking
· System Monitoring
· Solving Problems
· Security
· Installing and Upgrading
· Linux and Windows

Man Pages
Linux Topics
Test Your Knowledge

Site Menu
Site Map
Copyright Info
Terms of Use
Privacy Info
Masthead / Impressum
Your Account

Private Messages

News Archive
Submit News
User Articles
Web Links


The Web

Who's Online
There are currently, 60 guest(s) and 0 member(s) that are online.

You are an Anonymous user. You can register for free by clicking here




       mysqld [OPTIONS]


       mysqld    [--ansi]    [-b|--basedir=path]   [--big-tables]
       [--bind-address=IP]            [--character-sets-dir=path]
       [--chroot=path]   [-h|--datadir=path]   [--default-charac­
       ter-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-variablevar=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]


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

              Path to installation directory. All paths are  usu­
              ally resolved relative to this.

              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
              temporary tables and switching to disk tables where

              IP address to bind to.

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

              Chroot  mysqld  daemon  during startup. Recommended
              security measure. It will somewhat limit LOAD  DATA
              Don't  flush  key  buffers  between  writes for any
              MyISAM table. See Mysql Manual section 12.2.3  Tun­
              ing Server Parameters.

              Enable system locking.

              Print some debug info at exit.

              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.

              Display short help and exit.

              Read SQL commands from this file at startup.

              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?.

              Log connections and queries to file.

              Log all ISAM/MyISAM changes to file (only used when
              debugging ISAM/MyISAM).

              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 updates to file.# where # is a unique number if
              not given. See Mysql Manual section 21.3 The Update

              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.

              Table-modifying  operations  (INSERT/DELETE/UPDATE)

       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 giv­
              ing 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.

              Path to pid file used by mysqld_safe.

              Port number to listen for TCP/IP connections.

              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.

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

       -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  informa­
              tion  of  how  to  optimize these. See Mysql Manual
              section  12.2.3 Tuning Server Parameters.

              This option causes the server not to use the privi­
              lege system at all. This gives everyone full access
              ity  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 resolu­
              tions. MySQL Version 3.22 caches hostnames  (unless
              --skip-host-cache  is  used)  and  has  this option
              enabled by default.

              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 fea­

              Ignore  the  delay_key_write option for all tables.
              See Mysql  Manual  section   12.2.3  Tuning  Server

              Don't use system locking. To use isamchk or myisam­
              chk 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.

              Hostnames  are not resolved. All Host column values
              in the grant tables must be IP  numbers  or  local­

              Don't  listen  for  TCP/IP  connections at all. All
              interaction with mysqld must be made via Unix sock­
              ets.  This option is highly recommended 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.

              Don't  use  new,  possible  wrong routines. Implies

              Never use host name cache for faster name-ip  reso­
              lution,  but  query  DNS  server  on  every connect

              Don't allow 'SHOW DATABASE'  commands,  unless  the
              user has process privilege.

              Run mysqld daemon as user user_name. This option is
              mandatory when starting mysqld as root.

              Output version information and exit.



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


       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.mercurme­

MySQL 4.0                19 December 2000               mysqld(1)
Show your Support for the Linux Tutorial

Purchase one of the products from our new online shop. For each product you purchase, the Linux Tutorial gets a portion of the proceeds to help keep us going.



Security Code
Security Code
Type Security Code

Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.

Help if you can!

Amazon Wish List

Did You Know?
You can get all the latest Site and Linux news by checking out our news page.


Tell a Friend About Us

Bookmark and Share

Web site powered by PHP-Nuke

Is this information useful? At the very least you can help by spreading the word to your favorite newsgroups, mailing lists and forums.
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters. Articles are the property of their respective owners. Unless otherwise stated in the body of the article, article content (C) 1994-2013 by James Mohr. All rights reserved. The stylized page/paper, as well as the terms "The Linux Tutorial", "The Linux Server Tutorial", "The Linux Knowledge Base and Tutorial" and "The place where you learn Linux" are service marks of James Mohr. All rights reserved.
The Linux Knowledge Base and Tutorial may contain links to sites on the Internet, which are owned and operated by third parties. The Linux Tutorial is not responsible for the content of any such third-party site. By viewing/utilizing this web site, you have agreed to our disclaimer, terms of use and privacy policy. Use of automated download software ("harvesters") such as wget, httrack, etc. causes the site to quickly exceed its bandwidth limitation and are therefore expressly prohibited. For more details on this, take a look here

PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.10 Seconds