MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Access is Denied Error (plus "unexpected identifier" error on "USER" in SET USER, ALTER USER and CREATE USER commands)

Osman ZakirDec 13 2024 — edited Dec 13 2024

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?

Added on Dec 13 2024

#connection-problems, #db, #mysql-db

0 comments

139 views

MySQL Database

Access is Denied Error (plus "unexpected identifier" error on "USER" in SET USER, ALTER USER and CREATE USER commands)

Comments

Post Details