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
Subject
Views
Written By
Posted
1033
February 23, 2022 10:56AM
418
March 03, 2022 04:18PM
481
March 05, 2022 11:15AM
435
March 05, 2022 04:33PM
761
March 06, 2022 10:18AM
399
March 06, 2022 10:32AM
Re: Unable to sign into shell
402
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.