MySQL Forums
Forum List  »  MySQL Shell

Re: Unable to sign into shell
Posted by: alan scott
Date: March 05, 2022 11:15AM

Peter,
Thank you very much for your help.
I tried to follow your guidance and still had a problem with the shell as shown below.

MySQL Shell 8.0.28

Copyright (c) 2016, 2022, Oracle and/or its affiliates.
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 > mysqlsh -u root -p xxxxxxxxx --sql
SyntaxError: Unexpected identifier.

I have however managed to overcome the problem by using the Command Line Client that takes me into the Monitor rather than the Shell

Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 197
Server version: 8.0.28 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SELECT VERSION (), CURRENT_DATE;
+------------+--------------+
| VERSION () | CURRENT_DATE |
+------------+--------------+
| 8.0.28 | 2022-03-05 |

As a complete beginner I have no idea of the difference between the Shell and the Monitor but the Monitor does allow me to execute the Commands in the Tutorial.


Thank you again.

Options: ReplyQuote


Subject
Views
Written By
Posted
181
February 23, 2022 10:56AM
82
March 03, 2022 04:18PM
Re: Unable to sign into shell
73
March 05, 2022 11:15AM
81
March 05, 2022 04:33PM
90
March 06, 2022 10:18AM
73
March 06, 2022 10:32AM
76
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.