MySQL Forums
Forum List  »  Newbie

'root' is denied access to all databases/connections
Posted by: Phillip Powell
Date: February 25, 2023 10:34PM

I just reinstalled MySQL 8.0 (Developer [Default]) on my Windows 10-using laptop. Tried reconfiguring it to have at least two users:

root (I already have that)
dandy (I created that myself)

The 'dandy' user works just fine with its password for all db connections from my website pages that require db access.

The 'root' user, however, fails to access any databases at all in Workbench nor in Command Line Client: "Access is denied". I am completely shut out of using MySQL Command Line Client altogether as a result of this problem. This is impeding my ability to do any direct db commands onto the client such as "SHOW VARIABLES" or "SHOW FUNCTION STATUS.." etc.

I have no idea how to fix this; I am extremely new to all of this; I am a web front-end guy.

Please help if you can.


Options: ReplyQuote

Written By
'root' is denied access to all databases/connections
February 25, 2023 10:34PM

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.