MySQL Forums
Forum List  »  MySQL Shell

Re: Unable to sign into shell
Posted by: alan scott
Date: March 06, 2022 12:02PM

Peter,
Finally got through Shell into my database and able to execute SQL commands.
Thanks again for your help.

MySQL JS > \connect root@localhost:3306
Creating a session to 'root@localhost:3306'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 254
Server version: 8.0.28 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.
MySQL localhost:3306 ssl JS > \use whisky
Default schema set to `whisky`.
MySQL localhost:3306 ssl whisky JS > select * FROM whisky.bottle;
SyntaxError: Unexpected identifier
MySQL localhost:3306 ssl whisky JS > \sql
Switching to SQL mode... Commands end with ;
Fetching table and column names from `whisky` for auto-completion... Press ^C to stop.
MySQL localhost:3306 ssl whisky SQL > select * FROM whisky.bottle;
+----------+--------------------------------------------------------------------------+---------------+------------+----------+---------+-----+---------+--------------+------+-------------+---------------+
| bottleID | bottle_name | distillery_id | bottler_id | brand_id | type_id | age | vintage | year_bottled | abv | bottle_size | no_of_bottles |
+----------+--------------------------------------------------------------------------+---------------+------------+----------+---------+-----+---------+--------------+------+-------------+---------------+
| 1 | Glenallachie Trilogy Part 2 | 1 | 1 | | 1 | 14 | 2006 | 2020 | 61 | 70 | 677 |
| 2 | Arran White Stag Fourth Release

Options: ReplyQuote


Subject
Views
Written By
Posted
461
February 23, 2022 10:56AM
178
March 03, 2022 04:18PM
197
March 05, 2022 11:15AM
178
March 05, 2022 04:33PM
367
March 06, 2022 10:18AM
173
March 06, 2022 10:32AM
Re: Unable to sign into shell
179
March 06, 2022 12:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.