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 as 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 29 in Other DevOps Questions by Kichu
• 15,250 points

reshown Apr 30 by Hemant 26 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.

Related Questions In Other DevOps Questions

0 votes
1 answer

What is the best practice for updating an already existing web app deployment using ARM?

The Service Principal solution, through the SDK, ...READ MORE

answered Jul 9, 2018 in Other DevOps Questions by Atul
• 10,230 points
191 views
0 votes
1 answer

using Release Definition REST API for VSTS

Try using this: $vstsAccount = "[your vsts name]" $user ...READ MORE

answered Jul 24, 2018 in Other DevOps Questions by ajs3033
• 7,280 points
798 views
+1 vote
1 answer

Connection refused - connect(2) for “localhost” port 25 chef devops

With the information that you’ve provided it ...READ MORE

answered Jul 25, 2018 in Other DevOps Questions by Kalgi
• 52,350 points
1,026 views
0 votes
1 answer

What is MySQL Workbench?

MySQL Workbench is a designing or a ...READ MORE

answered Nov 29, 2018 in Database by Sahiti
• 6,360 points
142 views
0 votes
1 answer

MySQL Workbench Functionalities

The functionalities of MySQL Workbench are as ...READ MORE

answered Nov 29, 2018 in Database by Sahiti
• 6,360 points
330 views
0 votes
1 answer

What are the various MySQL Workbench editions?

MySQL Workbench is mainly available in three ...READ MORE

answered Dec 6, 2018 in Database by CodingByHeart77
• 3,720 points
217 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP