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
147
February 23, 2022 10:56AM
67
March 03, 2022 04:18PM
57
March 05, 2022 11:15AM
65
March 05, 2022 04:33PM
70
March 06, 2022 10:18AM
57
March 06, 2022 10:32AM
Re: Unable to sign into shell
61
March 06, 2022 12:02PM


Sorry, only registered users may post in this forum.

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.