Command Options

• mysqld and mysqld_safe have many command options.
  • For a brief summary, execute mysqld --help.
  • For a full list, execute mysqld --verbose --help.

• Some command options are:
  • --ansi
    • Use standard (ANSI) SQL syntax instead of MySQL syntax.
  • --default-storage-engine=type
    • Set the default storage engine (table type) for tables
  • --default-default-table-type=type
    • This option is a synonym for --default-storage-engine.
  • --log[=file_name]
    • Log connections and SQL statements received from clients to this file.
    • If omitted, MySQL uses host_name.log as the filename.
  • --log-error[=file_name]
    • Log errors and startup messages to this file.
    • If omitted, MySQL uses host_name.err as the filename.
  • --skip-grant-tables
    • Causes the server not to use the privilege system at all, which gives anyone with access to the server unrestricted access to all databases.
  • --skip-innodb
    • Disable the InnoDB storage engine.
    • Saves memory and disk space and may speed up some operations.
    • Do not use this option if InnoDB tables are required.
  • --user={user_name|user_id}, -u {user_name|user_id}
    • Run the mysqld server as the user having the name user_name or the numeric user ID user_id.
    • This option is mandatory when starting mysqld as root.

What are the MySQL system variables?

---

---

© 2007 John Michael Pierobon

Notes