Re: Unable to sign into shell

[alan scott]

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