Public Repository

Last pushed: a year ago
Short Description
Preview images for MySQL Shell. Created, maintained and supported by the MySQL team at Oracle
Full Description

What is MySQL Shell?

MySQL Shell is a new command line client that supports interaction with MySQL Server through Javascript, Python and SQL. It covers the same area of usage as the mysql command line client, so you can use it to perform classical relational SQL operations, while introducing a whole new area of functionality to query, update and manage MySQL as a document store, using popular scripting languages. More information about MySQL's new document store functionality is available at https://dev.mysql.com/doc/refman/5.7/en/document-store.html

MySQL Shell is currently in alpha, and this Docker image is meant only for the purpose of previewing upcoming features.

Enabling the mysqlx plugin on the MySQL server

The new document store features of MySQL are implemented as a plugin to MySQL Server. This plugin needs to be enabled on the server before you can use the shell to access the new functionality.

Invoke the shell as follows:

docker run -it -e MYSQL_HOST=<hostname> mysql/shell init

Or, if you have MySQL Server running in a Docker container named e.g. mysql-container-name, modify the command line as follows:

docker run -it --link mysql-container-name -e MYSQL_HOST=mysql-container-name mysql/shell init

You will be asked to enter the password for the server's root user. You should then see a message to the effect that the mysqlx plugin has been installed.

Connecting to a mysqlx enabled MySQL server

To connect to the server, simply run the mysql-shell image the same way you would start a normal MySQL client:

docker run -it mysql/shell -u <username> -h <hostname>

Or, if you have MySQL Server running in a Docker container named e.g. mysql-container-name, use the following command line:

docker run -it --link mysql-container-name mysql/shell -u <username> -h mysql-container-name

Once logged in, if you run \status, the shell should respond with Session type: X.

Using MySQL Shell

For information on how to use MySQL Shell, refer to the user guide at https://dev.mysql.com/doc/refman/5.7/en/mysql-shell.html

Supported Docker Versions

These images are officially supported by the MySQL team on Docker version 1.11. Support for older versions (down to 1.0) is provided on a best-effort basis, but we strongly recommend running on the most recent version, since that is assumed for parts of the documentation above.

User Feedback

We welcome your feedback! For general comments or discussion, please drop us a line in the Comments section below. For bugs and issues, please submit a bug report at http://bugs.mysql.com under the category "MySQL Package Repos and Docker Images".

Docker Pull Command
Owner
mysql

Comments (0)