Score:0

Accidentically remove grant privileges for root MySQL

us flag

I accidentically removed grant from the user_accounts tab (privileges) for root account

I have this extra account backend_dev_team

enter image description here

Now edit privileges clickable link is missing can I undo it?

UPDATE

GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost'; but gave me error access denied, I entered this using backend_dev_team and root account

Score:0
us flag

I login using SSH and use this command

sudo -i

This will allow you to login as root

and from there

mysql -u backend_dev_team -p (this is your account who has grant option)

and type this

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

flush privileges

refresh phpmyadmin

and you will see edit privileges clickable link.

and that's it! Thanks

in flag
You don't need `FLUSH PRIVILEGES` here see https://stackoverflow.com/a/36464093/2716218
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.