如何在mysql-js JavaScript模式下启动mysql-shell？

Question

如何将mysqlsh外壳更改为mysql-js JavaScript模式？

一开始我在mysql-py，我不能切换到\js，只能切换到\sql。为什么？

$ mysqlsh root@localhost:33060
Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
Please provide the password for 'root@localhost:33060': ******
MySQL Shell 8.0.23

Copyright (c) 2016, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Type '\help' or '\?' for help; '\quit' to exit.
Creating a session to 'root@localhost:33060'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 240 (X protocol)
Server version: 8.0.27-0ubuntu0.20.04.1 (Ubuntu)
No default schema selected; type \use <schema> to set one.
mysql-py []> \js
Unknown command: '\js'
mysql-py []> \sql
Switching to SQL mode... Commands end with ;
mysql-sql []> 

安装自：apt snap install mysql-shell。

Answer 1

不幸的是，snap mysql-shell在编译时没有js模块.

手动安装它：

https://dev.mysql.com/downloads/shell/

sudo dpkg -i mysql-shell_8.0.27-1ubuntu20.04_amd64.deb