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
• 19,040 points

reshown Apr 30 by Hemant 1,388 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 by narikkadan
• 18,480 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,230 points
225 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
842 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,109 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,380 points
172 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,380 points
356 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
257 views
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 in Other DevOps Questions by narikkadan
• 18,480 points
1,083 views
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