Tuesday, 3 December 2013

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;

No comments:

Post a comment