Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.9Mb
PDF (A4) - 37.9Mb
PDF (RPM) - 37.2Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 214.6Kb
Man Pages (Zip) - 327.5Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  mysqlsh — The MySQL Shell

4.5.7 mysqlsh — The MySQL Shell

MySQL Shell is an advanced command-line client and code editor for the MySQL Server. In addition to SQL, MySQL Shell also offers scripting capabilities for JavaScript and Python. When MySQL Shell is connected to the MySQL Server through the X Protocol, the X DevAPI can be used to work with both relational and document data. For information about using MySQL Shell, see Chapter 18, MySQL Shell User Guide.

mysqlsh supports the following command-line options.

Table 4.16 mysqlsh Options

--appUse stored session data. Removed in version 1.0.8.
--auth-methodAuthentication method to use
--classicCreate a ClassicSession
--databaseThe schema to use (alias for --schema)
--dbaEnable X Protocol on connection with server
--dbpasswordPassword to use when connecting to server
--dbuserMySQL user name to use when connecting to server
--executeExecute the command and quit
--fileFile to process in Batch mode
--forceContinue in SQL and Batch modes even if errors occur
--helpDisplay help message and exit
--hostConnect to MySQL server on given host
--interactiveEmulate Interactive mode in Batch mode
--jsStart in JavaScript mode
--jsonPrint output in JSON format
--log-levelSpecify logging level
--no-wizardDisable the connection wizard
--nodeCreate a NodeSession
--passwordPassword to use when connecting to server (alias for --dbpassword)
--passwords-from-stdinRead the password from stdin
--portTCP/IP port number to use for connection
--pyStart in Python mode
--recreate-schemaDrop and recreate schema
--schemaThe schema to use
--session-typeType of session to create. Removed in version 1.0.4.
--show-warningsShow warnings after each statement if there are any (in SQL mode)
--socketFor connections to localhost, the Unix socket file to use, or pipe name on Windows (ClassicSessions only)
--sqlStart in SQL mode
--sqlcStart in SQL mode using a ClassicSession
--sqlnStart in SQL mode using a NodeSession
--sslEnable an SSL connection
--ssl-caPath of file that contains list of trusted SSL CAs
--ssl-capathPath of directory that contains trusted SSL CAs
--ssl-certPath of file that contains X509 certificate in PEM format
--ssl-cipherName of the SSL cipher to use
--ssl-crlName of the SSL certificate revocation list
--ssl-crlpathPath of the SSL certificate revocation list
--ssl-keyPath of file that contains X509 key in PEM format
--tableDisplay output in tabular format
--tls-versionTLS version to use for SSL connections
--uriSession information in URI format
--userMySQL user name to use when connecting to server (alias for --dbuser)
--versionDisplay version information and exit
--verticalDisplay all SQL results vertically
--xCreate an XSession. Removed in version 1.0.8.

User Comments
Sign Up Login You must be logged in to post a comment.