Chapter 4 Getting Started with MySQL Shell

Table of Contents

4.1 Starting MySQL Shell

4.2 MySQL Shell Sessions

4.2.1 Creating the Session Global Object While Starting MySQL Shell

4.2.2 Creating the Session Global Object After Starting MySQL Shell

4.2.3 Scripting Sessions in JavaScript and Python Mode

4.3 MySQL Shell Connections

4.3.1 Connecting using Individual Parameters

4.3.2 Connecting using login-path and Options Files

4.3.3 Connecting using Unix Sockets and Windows Named Pipes

4.3.4 Using Encrypted Connections

4.3.5 Using LDAP and Kerberos Authentication

4.3.6 Using an SSH Tunnel

4.3.7 Using Compressed Connections

4.4 Pluggable Password Store

4.4.1 Pluggable Password Configuration Options

4.4.2 Working with Credentials

4.5 MySQL Shell Global Objects

4.6 Using a Pager

4.7 Cloud Service Configuration

4.7.1 Oracle Cloud Infrastructure Object Storage

4.7.2 S3-compatible Storage

4.7.3 Azure Blob Storage

4.8 OCI Authentication Connection Options

This section describes how to get started with MySQL Shell, explaining how to connect to a MySQL server instance, and how to choose a session type.

Important

It is recommended that you always use the most recent version available. The latest version of MySQL Shell can be used with any version of MySQL 5.7, 8.0, or 8.1.