MySQL Forums
Forum List  »  Newbie

Password and commands do not work
Posted by: William Fulton
Date: March 18, 2024 05:31PM

So I just installed MySQL because it's part of a Python course on working with databases. The installation was fine, it confirmed I was connected, and Pycharm also installed and imported the connector with no problem.

But on the Pycharm platform, it refuses to let me connect, saying "caching_sha2_password' is not supported". I have tried mysql_native_password, caching_sha2_password, and the personal one I used when installing, and it still says the same thing.

Also, NONE of the regular upper case commands will work, like SHOW DATABASES; in either Shell or on Pycharm. It acts as if they're completely unrecognized. Since a lot of the resources are from a while back, I'm not sure whether they've changed their syntax or not.

I already changed to sql mode, and it makes no difference. What's going on? In this worth trying to fix? Thanks.

Options: ReplyQuote

Written By
Password and commands do not work
March 18, 2024 05:31PM

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.