'My all access privileges for root@localhost are lost and I am unable to give access to the same on windows

I have tried all options like GRANT ALL PRIVILEGES ON . TO root@localhost IDENTIFIED BY 'yournewrootpassword' WITH GRANT OPTION;

also tried update command but all those access are also removed mistakenly.

mysqllocalhostrootmysql-error-1064access-denied


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions