CODEWITHSUNDEEP
mysql
Ran Hilai
Ran Hilai

Reputation: 3

MySQL Command-line client

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

Upvotes: 0

Views: 1011

Answers (2)

Sal
Sal

Reputation: 1317

You want MySQL Client.

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

Upvotes: 1

UrbanwarfareStudios
UrbanwarfareStudios

Reputation: 360

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

Upvotes: 0

Related Questions