Hi, everyone.
Whenever I try to login to MySQL Server via the Command Prompt (I'm using Windows 10, by the way), I get an “access is denied” error, and this happens whether I try to do it with or without a password. When I try to create or update the user using the MySQL Shell (version 8.0.40) using the “ALTER USER” command, I get a syntax error telling me that “USER” is an unexpected identifier, and I get the same error when trying to use “SET USER" and “CREATE USER” as well.
Anyone have an idea how can I solve this issue?