After you have installed and started MySQL server, connect MySQL Shell to the server instance. By default, MySQL Shell connects using X Protocol. You need to know the address of the MySQL server instance you plan to connect to.
If MySQL Shell is not already running, open a terminal window and issue:
Alternatively, if MySQL Shell is already running use the
\connect command by issuing:
You need to specify the address of your MySQL server instance which you want to connect MySQL Shell to. For example in the previous example:
namerepresents the user name of your MySQL account.
MySQL Shell prompts you for your password.
The default schema for this session is the
world_xdatabase. For instructions on setting up the
world_xdatabase sample, see Section 20.3.1, “Import Database Sample”.
Once MySQL Shell opens, the
prompt indicates that the active language for this session is
When you run mysqlsh without the host argument, MySQL Shell attempts to connect to the server instance running on the localhost interface on port 33060. For more information, see MySQL Shell Connections.
MySQL Shell supports input-line editing as follows:
left-arrow and right-arrow keys move horizontally within the current input line.
up-arrow and down-arrow keys move up and down through the set of previously entered lines.
Backspace deletes the character before the cursor and typing new characters enters them at the cursor position.
Enter sends the current input line to the server.
Type mysqlsh --help at the prompt of your command interpreter for a list of command-line options.
\help at the MySQL Shell prompt for a
list of available commands and their descriptions.
\help followed by a command name for
detailed help about an individual MySQL Shell command. For
example, to view help on the
mysql-js> \help \connect
See Interactive Code Execution for an explanation of how interactive code execution works in MySQL Shell.
See Getting Started with MySQL Shell to learn about session and connection alternatives.
See Section 4.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value Pairs” to learn about specifying the location of a MySQL server.