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, 2022 in Other DevOps Questions by Kichu
• 19,050 points

reshown Apr 30, 2022 by Hemant 4,078 views

1 answer to this question.

0 votes

Use the instructions for resetting the root password. Just forcefully INSERT a record into the mysql.user table instead of resetting the root password.

In the init file, use this instead:

INSERT INTO mysql.user (Host, User, Password) VALUES ('%', 'root', password('YOURPASSWORD'));

GRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION;

I hope this helps.

answered Apr 30, 2022 by narikkadan
• 63,680 points

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,240 points
604 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,300 points
1,234 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,637 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,370 points
667 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,370 points
1,006 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,750 points
814 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

This application has no explicit mapping for /error

One of the reason this error coccured ...READ MORE

answered May 2, 2022 in Other DevOps Questions by narikkadan
• 63,680 points
20,277 views
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