Mac OS X,  Mac OS X Server,  Mac Security

mysql command switches

Mysql command options:

–auto-rehash Enable or disable automatic rehashing
–auto-vertical-output Automatically display output of commands vertically rather than horizontally
–batch Do not write to the history file

–binary I use this when I have large results timing out due to blobs being in there
–bind-address Specify a network interface when connecting to the server
–character-sets-dir Indicate a custom directory where character sets are installed
–column-names Output column names when running queries
–column-type-info Show metadata
–comments Enable or disable commenting when sending statements to the server
–compress Compresses data sent to/from client and server
–connect_timeout Seconds of inactivity before a timeout
–database The database to connect to
–debug Write debugging log; supported only if MySQL was built with debugging support
–debug-check Print debugging information when program exits
–debug-info Print debugging information, memory, and CPU statistics when program exits
–default-auth Authentication plugin to use
–default-character-set Specify default character set
–defaults-extra-file Read named option file in addition to usual option files
–defaults-file Read only named option file
–defaults-group-suffix Option group suffix value
–delimiter Set the statement delimiter
–enable-cleartext-plugin Enable cleartext authentication plugin
–execute Execute the statement and quit
–force Continue even if an SQL error occurs
–help Display help message and exit
–histignore Patterns specifying which statements to ignore for logging
–host Connect to MySQL server on given host
–html Produce HTML output
–ignore-spaces Ignore spaces after function names
–init-command SQL statement to execute after connecting
–line-numbers Write line numbers for errors
–local-infile Enable or disable for LOCAL capability for LOAD DATA INFILE
–login-path Read login path options from .mylogin.cnf
–max_allowed_packet Maximum packet length to send to or receive from server
–max_join_size The automatic limit for rows in a join when using –safe-updates
–named-commands Enable named mysql commands
–net_buffer_length Buffer size for TCP/IP and socket communication
–no-auto-rehash Disable automatic rehashing
–no-beep Do not beep when errors occur
–no-defaults Read no option files
–one-database Ignore statements except those for the default database named on the command line
–pager Use the given command for paging query output
–password Password to use when connecting to server
–pipe On Windows, connect to server using named pipe
–plugin-dir Directory where plugins are installed
–port TCP/IP port number to use for connection
–print-defaults Print default options
–prompt Set the prompt to the specified format
–protocol Connection protocol to use
–quick Do not cache each query result
–raw Write column values without escape conversion
–reconnect If the connection to the server is lost, automatically try to reconnect
–safe-updates Only process UPDATE and DELETE statements when they have values
–secure-auth Do not send passwords to server in old (pre-4.1) format 5.7.5
–select_limit The automatic limit for SELECT statements when using –safe-updates
–server-public-key-path Path name to file containing RSA public key
–shared-memory-base-name The name of shared memory to use for shared-memory connections
–show-warnings Show warnings after each statement if there are any
–sigint-ignore Ignore SIGINT signals (typically the result of typing Control+C)
–silent Run silently (necessary when daemonizing)
–skip-auto-rehash Disable automatic rehashing
–skip-column-names Do not write column names in results
–skip-line-numbers Skip line numbers for errors
–skip-named-commands Disable named mysql commands
–skip-pager Disable paging
–skip-reconnect Disable reconnecting
–socket For connections to localhost, the Unix socket file to use
–ssl Enable secure connection
–ssl-ca Path of file that contains list of trusted SSL CAs
–ssl-capath Path of directory that contains trusted SSL CA certificates in PEM format
–ssl-cert Path of file that contains X509 certificate in PEM format
–ssl-cipher List of permitted ciphers to use for connection encryption
–ssl-crl Path of file that contains certificate revocation lists
–ssl-crlpath Path of directory that contains certificate revocation list files
–ssl-key Path of file that contains X509 key in PEM format
–ssl-mode Security state of connection to server 5.7.11
–ssl-verify-server-cert Verify server certificate Common Name value against host name used when connecting to server
–syslog Log interactive statements to syslog 5.7.1
–table Display output in tabular format
–tee Append a copy of output to named file
–tls-version TLS versions Protocols permitted for secure connections
–unbuffered Constantly flush buffers
–user The user name to use when connecting to server (SQL users are not the same as users on an OS)
–verbose As with most other commands, output verbosely
–version Show the MySQL version number
–vertical Show one line per column in query outputs
–wait Retry when a connection fails
–xml Output data into an XML format