mysqlsh

Advanced command-line client for MySQL, supporting SQL, JavaScript, and Python.

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