Mysqlsh:mysql Shell Tutorial

The MySQL Shell is an advanced command-line client as well as a code editor for Mysql.

In addition to the Sql,mysql shell also provides scripting capabilities for JS and Python.

When MySQL shell was conected to the MySQL server throught the x protocol, the X DEVAPI can being used to work with both Relat ional and documnet data,

The Official tutorial 8.0 version of the 20th chapter is introduced.

MySQL contains Adminapi, allowing you to collaborate with InnoDB cluster. See chapter 21st.

Simple option Introduction.

Https://dev.mysql.com/doc/refman/8.0/en/mysqlsh.html

===================tutorial++++++++++++++++++++++++++

Features:

Gobal session:interactive with a MySQL server was done through a Session object.

For SQL mode, the concept of Global session was supported by the MySQL shell.

A Global session is created when the connection infromation are passed to MySQL shell using command options,

or by using the \connect Command.here is a example below:

\connect URI;

In this example, the input error should be written \connect [email protected]:3306/test cannot be appended with a semicolon.

1. MySQL Shell Connections

1.1 can connect to MySQL server using both the X protocol and the classic MySQL protocol.

The address fo the MySQL server which want to connect to can is specified using individual parameters, such as user, H Oustname and port, or using a Uniform Resource Identifier (URI) type string.

1.2. connectiing to the MySQL server.

1.2.1 mSQL Shell is not started: start with parameters

• --dbuser(-u)value

• --dbpassword(-p)value

• --host(-h)value

• --port(-P)value

• --schema(-D)value

• --no-password, or with an --password= empty value, if the user is connecting without a password

• --socket(-S)

1.2.2 When MySQL Shell is running

Using the \connect command.

1.2.3

After that in:

Https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-connection-options.html

Inquire.

Mysqlsh:mysql Shell Tutorial