Mysql ERROR : not connected

Question

I am trying to connect to MySQL database from MySQL shell on windows.

No matter what I type in MySQL shell, it keeps giving me error : 'Not connected'.

Query eg 1 : mysql --host=localhost --port=3306 --user=root -p;

Query eg 2 : mysql -u root -p

O/P : ERROR: Not connected

I have MySQL server installed on my machine. Also MySQL service is running in the background.

Also, I was able to connect from MySQL workbench.

ERROR MESSAGE

MySQL Workbench Connection

Answer 1

My temporary workaround is that I make use of ssl protocol to connect to MySQL server :

MySQL> \connect root@localhost

MySQL localhost:33060+ ssl SQL > show databases;