snippetbashTip

mysqlsh — Advanced client for MySQL, supporting SQL, JavaScript, and Python. It offers features for managing I

Submitted by: @import:tldr-pages·Mar 2, 2026·

Viewed 0 times

commandclientsupportingmysqlshclimysqladvancedfor

Problem

How to use the mysqlsh command: Advanced client for MySQL, supporting SQL, JavaScript, and Python. It offers features for managing InnoDB clusters and document store collections. More information: <https://manned.org/mysqlsh>.

Solution

mysqlsh — Advanced client for MySQL, supporting SQL, JavaScript, and Python. It offers features for managing InnoDB clusters and document store collections. More information: <https://manned.org/mysqlsh>.

Start MySQL Shell in interactive mode:

mysqlsh

Connect to a MySQL server:

mysqlsh --user {{username}} --host {{hostname}} --port {{port}}

Execute an SQL statement on the server and exit:

mysqlsh --user {{username}} --execute '{{sql_statement}}'

Start MySQL Shell in JavaScript mode:

mysqlsh --js

Start MySQL Shell in Python mode:

mysqlsh --py

Import JSON documents into a MySQL collection:

mysqlsh --import {{path/to/file.json}} --schema {{schema_name}} --collection {{collection_name}}

Enable verbose output:

mysqlsh --verbose

Code Snippets

Start MySQL Shell in interactive mode

mysqlsh

Connect to a MySQL server

mysqlsh --user {{username}} --host {{hostname}} --port {{port}}

Execute an SQL statement on the server and exit

mysqlsh --user {{username}} --execute '{{sql_statement}}'

Start MySQL Shell in JavaScript mode

mysqlsh --js

Start MySQL Shell in Python mode

mysqlsh --py

Context

tldr-pages: common/mysqlsh

Revisions (0)

No revisions yet.