Advertisement
Guest User

Untitled

a guest
Apr 21st, 2019
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. FORMAT:
  2. ------------
  3. GRANT ALL PRIVILEGES ON <db-name> TO '<db user>'@'%' IDENTIFIED BY '<db-password>';
  4. ------------------------------------------------------------------------------
  5.  
  6.  
  7. GRANT ALL ON test_wasa.* TO root@'%' IDENTIFIED BY 'password'; // here only access to "test_wasa" DB
  8.  
  9.  
  10. GRANT ALL PRIVILEGES ON *.* TO 'papel'@'%' IDENTIFIED BY 'password'; //here access to ALL DB
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement