Link Search Menu Expand Document


Advanced command-line client for MySQL, supporting SQL, JavaScript, and Python. It offers features for managing InnoDB clusters and document store collections. More information:

  • Start MySQL Shell in interactive mode:


  • 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