MySQL Command-line client

Question

I'm trying to install and use the MySQL Command-line client on windows, as documented here: https://dev.mysql.com/doc/refman/5.5/en/mysql.html

After installing MySQL I found a program "MySQL Shell". When I run it, it prompts

MySQL Shell 8.0.14

Copyright (c) 2016, 2019, Oracle and/or its affiliates. All rights reserved.
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.

MySQL JS>

instead of prompting "Shell". Is that the same tool? how do I run it in Shell mode?

If it's not the same tool, where can the install for the one I'm looking for?

Thanks

Sal · Accepted Answer · 2019-01-30 19:12:17Z

1

You want MySQL Client.

Looks like you installed MySQL Shell, enter \sql to allow SHOW DATABASES; command.

answered Jan 30, 2019 at 19:12

Sal

1,3171 gold badge8 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ran Hilai Over a year ago

Thanks. Can you add a link for MySQL Client Install for windows? it's embarrassing but we're looking for it and can't find it.

UrbanwarfareStudios · Accepted Answer · 2019-01-30 17:36:46Z

0

It looks like your in shell but already using MySQL. If you type in:

SHOW DATABASES;

What does it say?

If your looking to develop on your windows machine had you considered using a GUI like PhpMyAdmin? (if your intending to code in PHP I can highly recommend XAMPP)

its really useful and comes with PhpMyAdmin as standard

answered Jan 30, 2019 at 17:36

UrbanwarfareStudios

3606 silver badges18 bronze badges

1 Comment

Ran Hilai Over a year ago

I get: MySQL JS> show databases SyntaxError: Unexpected identifier I read that "MySQL JS" means Java Script. I want the command-line tool as described here: dev.mysql.com/doc/refman/5.5/en/mysql.html I just need it for a POC, I want it because it should be fast and simple.

Collectives™ on Stack Overflow

MySQL Command-line client

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related