Re: Unable to sign into shell

[alan scott]

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.