shell.options.sandboxDir='C:\Users\IGittler\MySQL\mysql-sandboxes'
Showing posts with label MySQL Shell. Show all posts
Showing posts with label MySQL Shell. Show all posts
MySQL Shell - Dba.deploySandboxInstance: ERROR: Error creating sandbox: Could not find mysqld executable. Make sure it is on the %PATH% environment variable.
Error message:
MySQL JS > dba.deploySandboxInstance(3310)
A new MySQL sandbox instance will be created on this host in
C:\Users\IGittler\MySQL\mysql-sandboxes\3310
Warning: Sandbox instances are only suitable for deploying and running on your local machine for testing purposes and are not accessible from external networks.
Please enter a MySQL root password for the new instance: ******
Deploying new MySQL instance...
Dba.deploySandboxInstance: ERROR: Error creating sandbox: Could not find mysqld executable. Make sure it is on the %PATH% environment variable. (RuntimeError)
Solutions:
- Check path definitions.
- MySQL Server should be installed on the machine.
MySQL Shell - deploySandboxInstance
deploySandboxInstance creates a new MySQL Server instance on localhost.
dba.deploySandboxInstance(port[, options])
MySQL JS > dba.deploySandboxInstance(3310)
MySQL Shell
MySQL Shell provides an interactive code execution mode, where you type code at the MySQL Shell prompt and each entered statement is processed, with the result of the processing printed onscreen.
MySQL Shell is an advanced client and code editor for MySQL Server.
In addition to the provided SQL functionality, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL.
MySQL Shell is a component that you can install separately.
Install MySQL Shell:
download from: https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-install.html
Extract the downloaded zip file.
Start MySQL Shell:
Run \bin\mysqlsh.exe.
MySQL Shell 8.0 documentation:
https://dev.mysql.com/doc/mysql-shell/8.0/en/
Subscribe to:
Posts (Atom)