What Is MySQL Shell

MySQL Tutorials - Herong's Tutorial Examples

∟What Is MySQL Shell

Quick introduction of MySQL Shell and ways to start it and access the local MySQL server.

What Is MySQL Shell? MySQL Shell is an advanced client and code editor for MySQL Server. It allows you to connect to a MySQL Server to run SQL commands, similar to the "mysql" command line tool. It also allows you to run JavaScript and Python scripts to interface with a MySQL Server.

MySQL Shell is included in the "Full" installation using MySQL Installer.

You can start MySQL Shell from Windows "Start" button or from the "C:\Program Files\MySQL\MySQL Shell 8.0\bin\mysqlsh.exe" command.

Make sure MySQL server is running and try the following commands to play with MySQL Shell:

herong> "\Program Files\MySQL\MySQL Shell 8.0\bin\mysqlsh"

MySQL Shell 8.0.16

Copyright (c) 2016, 2019, Oracle and/or its affiliates.

Type '\help' or '\?' for help; '\quit' to exit.

 MySQL  JS > print("Hello world!");
Hello world!
 MySQL  JS > \py
Switching to Python mode...

 MySQL  Py > print("Hello world!")
Hello world!

 MySQL  Py > \connect root@localhost
Creating a session to 'root@localhost'
Please provide the password for 'root@localhost': *********
Save password for 'root@localhost'? [Y]es/[N]o/Ne[v]er (default No): N
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 15 (X protocol)
Server version: 8.0.16 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.

 MySQL  localhost:33060+ ssl  Py > \sql show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| world              |
+--------------------+
6 rows in set (0.0005 sec)

 MySQL  localhost:33060+ ssl  Py > \sql select "Hello world!";
+--------------+
| Hello world! |
+--------------+
| Hello world! |
+--------------+
1 row in set (0.0003 sec)

 MySQL  localhost:33060+ ssl  Py > \exit