Home / server / Questions / 1074523
Accepted
Pablo
Asked: 2021-08-14 14:46:32 +0800 CST

Accidentically remove grant privileges for root MySQL

  • 772

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

mysql phpmyadmin

1 Answers

  1. Best Answer

    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

    • 0