localhost is not allowed to connect to this mysql server
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
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.