Advertisement
kura2yamato

grant access

May 2nd, 2022
1,075
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.31 KB | None | 0 0
  1. REVOKE ALL PRIVILEGES ON *.* FROM 'belajar'@'localhost';
  2.  
  3. REVOKE GRANT OPTION ON *.* FROM 'belajar'@'localhost';
  4.  
  5. GRANT SELECT, CREATE ON *.* TO 'belajar'@'localhost'
  6. REQUIRE NONE WITH
  7. MAX_QUERIES_PER_HOUR 0
  8. MAX_CONNECTIONS_PER_HOUR 0
  9. MAX_UPDATES_PER_HOUR 0
  10. MAX_USER_CONNECTIONS 0;
  11.  
  12. flush privileges;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement