Debug School

rakesh kumar
rakesh kumar

Posted on

How to set PRIVILEGES using grant and revoke

REVOKE

REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'root'@'localhost';
Enter fullscreen mode Exit fullscreen mode

GRANT 

GRANT ALL ON *.* TO 'root'@'localhost';
Enter fullscreen mode Exit fullscreen mode 
grant all privileges on mydb.* to myuser@localhost identified by 'mypasswd';
Enter fullscreen mode Exit fullscreen mode

Top comments (0)