MySQL Forums
Forum List  »  Newbie

localhost is not allowed to connect to this mysql server
Posted by: Vaughan Wickham
Date: October 23, 2021 04:34PM

Hello,

The MySQL host computer restarted overnight unexpectedly, and when I tried to connect to MySQL this morning, I get error:

localhost is not allowed to connect to this mysql server

After doing some research, so far I've worked out

- if I add: skip-grant-tables to my.ini and restart the server I can logon
- there are no users listed in the user list
- if I try to add root, I get an error about can't add users due to skip-grant-tables being enabled

Appreciate suggestions on how to resolve

Thanks

VW

Options: ReplyQuote


Subject
Written By
Posted
localhost is not allowed to connect to this mysql server
October 23, 2021 04: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.