Virtual Database Support
MySQL
ORACLE
ORACLE-RAC
Microsoft SQL Server
PostgresDB
UNIX
Windows
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment