I have removed the 'root' user and its privilege accidentally.
I have removed the 'root' user and its privilege accidentally. recreated 'root' user but not able to grant permission to 'root' user and getting below error. Please help me to grant permission to root user.
NewMySQL>grant all privileges on *.* to 'root'@'localhost' with grant option;
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)