Access Denied for User root localhost using password YES - No Privileges

0 votes

I use MySQL Workbench and I continuously get this error. The root@127.0.0.1 apparently has a lot of access but, I am logged in like that, but it just assigns to localhost anyways - localhost has no privileges. When running SHOW GRANTS FOR root this is what I get in return:

Error Code: 1141. There is no such grant defined for user 'root' on host '%'

How can I get root its access back? Can someone please guide me on this?

Apr 30, 2022 in Other DevOps Questions by Kichu
• 19,040 points

edited 4 days ago 10 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP