MySQL Shell 8.0

抽象的

MySQL Shell 是 MySQL 的高级客户端和代码编辑器。本文档描述了 MySQL Shell 的核心特性。除了提供的 SQL 功能外，类似于 mysql，MySQL Shell 还为 JavaScript 和 Python 提供脚本功能，并包括用于与 MySQL 一起工作的 API。X DevAPI 使您能够处理关系数据和文档数据，请参阅 使用 MySQL 作为文档存储。AdminAPI 使您能够使用 InnoDB Cluster、InnoDB ClusterSet 和 InnoDB ReplicaSet。

强烈建议将 MySQL Shell 8.0 与 MySQL Server 8.0 和 5.7 一起使用。请升级到 MySQL Shell 8.0。如果您还没有安装 MySQL Shell，请从 下载站点下载它。

有关详细说明每个版本中更改的注释，请参阅 MySQL Shell 发行说明。

如需有关使用 MySQL 的帮助，请访问 MySQL 论坛，您可以在其中与其他 MySQL 用户讨论您的问题。

许可信息。 本产品可能包含第三方软件，在许可下使用。如果您使用的是 MySQL Shell 的 商业版本，请参阅MySQL Shell 商业许可信息用户手册以获取许可信息，包括与此商业版本中可能包含的第三方软件相关的许可信息。如果您使用的是MySQL Shell 的 社区版本，请参阅MySQL Shell 社区许可信息用户手册用于许可信息，包括与可能包含在此社区版本中的第三方软件相关的许可信息。

文档生成于：2023-05-18（修订版：75663）

目录

• 1 MySQL Shell 特性

• 2 安装MySQL外壳

• 3 使用 MySQL Shell 命令

• 4 MySQL Shell 入门

• 5 MySQL Shell 代码执行

• 6 MySQL 管理API

• 7 MySQL InnoDB集群

• 8 MySQL InnoDB集群集

• 9 MySQL InnoDB 副本集

• 10 扩展 MySQL Shell

• 11 MySQL Shell 实用程序

• 12 MySQL Shell 日志记录和调试

• 13 自定义 MySQL Shell

• MySQL Shell 命令参考3

译者注：
如何正确安装
# rpm -ivh mysql-shell-8.0.33-1.el7.x86_64.rpm  
warning: mysql-shell-8.0.33-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
error: Failed dependencies:
        libyaml-0.so.2()(64bit) is needed by mysql-shell-8.0.33-1.el7.x86_64
[root@cellsoft-m1-v1-node1 ~]# yum localinstall  mysql-shell-8.0.33-1.el7.x86_64.rpm  
Loaded plugins: fastestmirror, langpacks
Repository base is listed more than once in the configuration
Repository updates is listed more than once in the configuration
Repository extras is listed more than once in the configuration
Repository centosplus is listed more than once in the configuration
Examining mysql-shell-8.0.33-1.el7.x86_64.rpm: mysql-shell-8.0.33-1.el7.x86_64
Marking mysql-shell-8.0.33-1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-shell.x86_64 0:8.0.33-1.el7 will be installed
--> Processing Dependency: libyaml-0.so.2()(64bit) for package: mysql-shell-8.0.33-1.el7.x86_64
Loading mirror speeds from cached hostfile
epel/x86_64/metalink                                                                                              | 7.4 kB  00:00:00     
 * base: mirrors.bupt.edu.cn
 * epel: mirrors.bfsu.edu.cn
 * extras: mirrors.bupt.edu.cn
 * remi-php80: mirrors.tuna.tsinghua.edu.cn
 * remi-safe: mirrors.tuna.tsinghua.edu.cn
 * updates: mirrors.bupt.edu.cn
base                                                                                                              | 3.6 kB  00:00:00     
epel                                                                                                              | 4.7 kB  00:00:00     
extras                                                                                                            | 2.9 kB  00:00:00     
percona-release-noarch                                                                                            | 1.5 kB  00:00:00     
percona-release-x86_64                                                                                            | 2.9 kB  00:00:00     
prel-release-noarch                                                                                               | 1.5 kB  00:00:00     
remi-php80                                                                                                        | 3.0 kB  00:00:00     
remi-safe                                                                                                         | 3.0 kB  00:00:00     
updates                                                                                                           | 2.9 kB  00:00:00     
zabbix4-4-6                                                                                                       | 2.9 kB  00:00:00     
(1/7): epel/x86_64/group_gz                                                                                       |  99 kB  00:00:00     
(2/7): epel/x86_64/updateinfo                                                                                     | 1.0 MB  00:00:00     
(3/7): epel/x86_64/primary_db                                                                                     | 7.0 MB  00:00:00     
(4/7): updates/7/x86_64/primary_db                                                                                |  21 MB  00:00:00     
(5/7): remi-php80/primary_db                                                                                      | 228 kB  00:00:02     
(6/7): remi-safe/primary_db                                                                                       | 2.4 MB  00:00:02     
(7/7): percona-release-x86_64/7/primary_db                                                                        | 1.3 MB  00:00:03     
--> Running transaction check
---> Package libyaml.x86_64 0:0.1.4-11.el7_0 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================
 Package                    Arch                  Version                          Repository                                       Size
=========================================================================================================================================
Installing:
 mysql-shell                x86_64                8.0.33-1.el7                     /mysql-shell-8.0.33-1.el7.x86_64                224 M
Installing for dependencies:
 libyaml                    x86_64                0.1.4-11.el7_0                   base                                             55 k

Transaction Summary
=========================================================================================================================================
Install  1 Package (+1 Dependent package)

Total size: 224 M
Total download size: 55 k
Installed size: 224 M
Is this ok [y/d/N]: y
Downloading packages:
libyaml-0.1.4-11.el7_0.x86_64.rpm                                                                                 |  55 kB  00:00:00     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 22 pre-existing rpmdb problem(s), 'yum check' output follows:
mysql-community-embedded-compat-8.0.30-1.el7.x86_64 has missing requires of libaio.so.1()(64bit)
mysql-community-embedded-compat-8.0.30-1.el7.x86_64 has missing requires of libaio.so.1(LIBAIO_0.1)(64bit)
mysql-community-embedded-compat-8.0.30-1.el7.x86_64 has missing requires of libaio.so.1(LIBAIO_0.4)(64bit)
mysql-community-embedded-compat-8.0.30-1.el7.x86_64 has missing requires of libnuma.so.1()(64bit)
mysql-community-embedded-compat-8.0.30-1.el7.x86_64 has missing requires of libnuma.so.1(libnuma_1.1)(64bit)
mysql-community-embedded-compat-8.0.30-1.el7.x86_64 has missing requires of libnuma.so.1(libnuma_1.2)(64bit)
mysql-community-server-8.0.30-1.el7.x86_64 has missing requires of libaio.so.1()(64bit)
mysql-community-server-8.0.30-1.el7.x86_64 has missing requires of libaio.so.1(LIBAIO_0.1)(64bit)
mysql-community-server-8.0.30-1.el7.x86_64 has missing requires of libaio.so.1(LIBAIO_0.4)(64bit)
mysql-community-server-8.0.30-1.el7.x86_64 has missing requires of libnuma.so.1()(64bit)
mysql-community-server-8.0.30-1.el7.x86_64 has missing requires of libnuma.so.1(libnuma_1.1)(64bit)
mysql-community-server-8.0.30-1.el7.x86_64 has missing requires of libnuma.so.1(libnuma_1.2)(64bit)
mysql-community-server-8.0.30-1.el7.x86_64 has missing requires of net-tools
mysql-community-server-debug-8.0.30-1.el7.x86_64 has missing requires of libaio.so.1()(64bit)
mysql-community-server-debug-8.0.30-1.el7.x86_64 has missing requires of libaio.so.1(LIBAIO_0.1)(64bit)
mysql-community-server-debug-8.0.30-1.el7.x86_64 has missing requires of libaio.so.1(LIBAIO_0.4)(64bit)
mysql-community-server-debug-8.0.30-1.el7.x86_64 has missing requires of libnuma.so.1()(64bit)
mysql-community-server-debug-8.0.30-1.el7.x86_64 has missing requires of libnuma.so.1(libnuma_1.1)(64bit)
mysql-community-server-debug-8.0.30-1.el7.x86_64 has missing requires of libnuma.so.1(libnuma_1.2)(64bit)
mysql-community-test-8.0.30-1.el7.x86_64 has missing requires of perl(JSON)
mysql-community-test-8.0.30-1.el7.x86_64 has missing requires of perl(JSON)
mysql-community-test-8.0.30-1.el7.x86_64 has missing requires of perl(Test::More)
  Installing : libyaml-0.1.4-11.el7_0.x86_64                                                                                         1/2 
  Installing : mysql-shell-8.0.33-1.el7.x86_64                                                                                       2/2 
  Verifying  : libyaml-0.1.4-11.el7_0.x86_64                                                                                         1/2 
  Verifying  : mysql-shell-8.0.33-1.el7.x86_64                                                                                       2/2 

Installed:
  mysql-shell.x86_64 0:8.0.33-1.el7                                                                                                      

Dependency Installed:
  libyaml.x86_64 0:0.1.4-11.el7_0                                                                                                        

Complete!