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
633
February 23, 2022 10:56AM
264
March 03, 2022 04:18PM
Re: Unable to sign into shell
276
March 05, 2022 11:15AM
288
March 05, 2022 04:33PM
568
March 06, 2022 10:18AM
248
March 06, 2022 10:32AM
252
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.