MajinGotenks

LF 8.3 Benutzer und Berechtigung

Jun 3rd, 2022
567
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.68 KB | None | 0 0
  1. CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin';
  2.  
  3. GRANT ALL PRIVILEGES ON antique . * TO 'admin'@'localhost';
  4.  
  5. CREATE USER 'Luka Kovacevic'@'localhost' IDENTIFIED BY 'passwort';
  6.  
  7. GRANT Drop, Delete, Update, Select, Insert, Create ON antique . * TO 'Luka Kovacevic'@'localhost';
  8.  
  9. CREATE USER 'Timo Krug'@'localhost' IDENTIFIED BY '12345678';
  10.  
  11. GRANT Update, Select, Insert ON antique . * TO 'Timo Krug'@'localhost';
  12.  
  13. CREATE USER 'Florian Haag'@'localhost' IDENTIFIED BY '12345678';
  14.  
  15. GRANT Select ON antique . * TO 'Florian Haag'@'localhost';
  16.  
  17. CREATE USER 'Hannes Pongratz'@'localhost' IDENTIFIED BY 'HmPTP2000';
  18.  
  19. GRANT Select ON antique . * TO 'Hannes Pongratz'@'localhost';
Advertisement
Add Comment
Please, Sign In to add comment