ERROR 1133 (42000): Can't find any matching row in the user table

Error :--

 

mysql>grant all privileges on *.* to root@'%' with grant option;

ERROR 1133 (42000): Can't find any matching row in the user table

 

 

Solution:--

 

Make root user as password protected..

 

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root123');

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root123' WITH GRANT OPTION;

Flush privileges;