The MySql database

      mysql.exe [OPTIONS] [database]

   --auto-rehash       Enable automatic rehashing. One doesn't need to use
                       'rehash' to get table and field completion, but startup
                       and reconnecting may take a longer time. Disable with
   -A, --no-auto-rehash
                       No automatic rehashing. One has to use 'rehash' to get
                       table and field completion. This gives a quicker start of
                       mysql and disables rehashing on reconnect.
   -B, --batch         Don't use history file. Disable interactive behavior.
                       (Enables --silent.)
                       Directory for character set files.
   --column-type-info  Display column type information.
   -c, --comments      Preserve comments. Send comments to the server. The
                       default is --skip-comments (discard comments), enable
                       with --comments.
   -C, --compress      Use compression in server/client protocol.
   -#, --debug[=#]     This is a non-debug version. Catch this and exit.
   --debug-check       Check memory and open file usage at exit.
   -T, --debug-info    Print some debug info at exit.
   -D, --database=name Database to use.
                       Set the default character set.
   --delimiter=name    Delimiter to be used.
   -e, --execute=name  Execute command and quit. (Disables --force and history file.)
   -E, --vertical      Print the output of a query (rows) vertically.
   -f, --force         Continue even if we get an SQL error.
   -G, --named-commands
                       Enable named commands. Named commands mean this program's
                       internal commands; see mysql> help . When enabled, the
                       named commands can be used from any line of the query,
                       otherwise only from the first line, before an enter.
                       Disable with --disable-named-commands. 
                       Disable named commands.
                       This option is disabled by default.
   -g, --no-named-commands
                       Disable named commands. Use \* form only, or use
                       named commands only in the beginning of a line ending
                       with a semicolon (;). Since version 10.9, the client now
                       starts with this option ENABLED by default. Disable with
                       '-G'. Long format commands still work from the first line. 
                       WARNING: option deprecated; use --disable-named-commands instead.
   -i, --ignore-spaces Ignore space after function names.
   --local-infile      Enable/disable LOAD DATA LOCAL INFILE.
   -b, --no-beep       Turn off beep on error.
   -h, --host=name     Connect to host.
   -H, --html          Produce HTML output.
   -X, --xml           Produce XML output.
   --line-numbers      Write line numbers for errors.
   -L, --skip-line-numbers
                       Don't write line number for errors.
   -n, --unbuffered    Flush buffer after each query.
   --column-names      Write column names in results.
   -N, --skip-column-names
                       Don't write column names in results.
   -O, --set-variable=name
                       Change the value of a variable. Please note that this
                       option is deprecated; you can set variables directly with
   --sigint-ignore     Ignore SIGINT (CTRL-C).
   -o, --one-database  Ignore statements except those that occur while the
                       default database is the one named at the command line.
   -p, --password[=name]
                       Password to use when connecting to server. If password is
                       not given it's asked from the tty.
   -W, --pipe          Use named pipes to connect to server.
   -P, --port=#        Port number to use for connection or 0 for default to, in
                       order of preference, my.cnf, $MYSQL_TCP_PORT,
                       /etc/services, built-in default (3306).
   --prompt=name       Set the mysql prompt to this value.
   --protocol=name     The protocol to use for connection (tcp, socket, pipe,
   -q, --quick         Don't cache result, print it row by row. This may slow
                       down the server if the output is suspended. Doesn't use
                       history file.
   -r, --raw           Write fields without conversion. Used with --batch.
   --reconnect         Reconnect if the connection is lost. Disable with
                       --disable-reconnect. This option is enabled by default.
   -s, --silent        Be more silent. Print results with a tab as separator,
                       each row on new line.
                       Base name of shared memory.
   -S, --socket=name   The socket file to use for connection.
   --ssl               Enable SSL for connection (automatically enabled with
                       other flags).Disable with --skip-ssl.
   --ssl-ca=name       CA file in PEM format (check OpenSSL docs, implies
   --ssl-capath=name   CA directory (check OpenSSL docs, implies --ssl).
   --ssl-cert=name     X509 cert in PEM format (implies --ssl).
   --ssl-cipher=name   SSL cipher to use (implies --ssl).
   --ssl-key=name      X509 key in PEM format (implies --ssl).
                       Verify server's "Common Name" in its cert against
                       hostname used when connecting. This option is disabled by
   -t, --table         Output in table format.
   --tee=name          Append everything into outfile. See interactive help (\h)
                       also. Does not work in batch mode. Disable with
                       --disable-tee. This option is disabled by default.
   --no-tee            Disable outfile. See interactive help (\h) also. WARNING:
                       Option deprecated; use --disable-tee instead.
   -u, --user=name     User for login if not current user.
   -U, --safe-updates  Only allow UPDATE and DELETE that uses keys.
   -U, --i-am-a-dummy  Synonym for option --safe-updates, -U.
   -v, --verbose       Write more. (-v -v -v gives the table output format).
   -V, --version       Output version information and exit.
   -w, --wait          Wait and retry if connection is down.
   --connect_timeout=# Number of seconds before connection timeout.
                       The maximum packet length to send to or receive from
                       The buffer size for TCP/IP and socket communication.
   --select_limit=#    Automatic limit for SELECT when using --safe-updates.
   --max_join_size=#   Automatic limit for rows in a join when using
   --secure-auth       Refuse client connecting to server if it uses old
                       (pre-4.1.1) protocol.
   --server-arg=name   Send embedded server this as a parameter.
   --show-warnings     Show warnings after every statement.
   -?, --help          Display help and exit.
   -I, --help          Synonym for -?

Default options

The default options are read from the 'my.ini and my.cnf' files.

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.
--defaults-file=#       Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.


Connect to the database 'ss64database' using the username/password user64/pa55w0rd :

./mysql -u user64 --password=pa55w0rd ss64database

Connect to the same database and run a query, line breaks added for clarity, but this would all be in one command line:

./mysql -u user64 --password=pa55w0rd -e "SELECT ips_Concat3(YEAR(T_log.LogTime),'-',MONTH(T_log.LogTime),'-',DAY(T_log.LogTime)) AS dtm,
                                          CASE T_log.Action WHEN 'file_upload' THEN 'Upload' WHEN 'file_download' THEN 'Download' ELSE
                                          T_log.Action END AS UpDown
                                          FROM T_log 
                                          ORDER BY YEAR(T_log.LogTime),MONTH(T_log.LogTime), DAY(T_log.LogTime)'
                                          " ss64database


MySQL Variables (--variable-name=value)

Copyright © 1999-2024
Some rights reserved