Advertisement
Guest User

Untitled

a guest
Dec 18th, 2016
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. DELETE FROM mysql.user WHERE user = 'demo';
  2. flush privileges;
  3. GRANT ALL PRIVILEGES ON *.* TO 'demo'@'localhost' ;
  4. GRANT ALL PRIVILEGES ON *.* TO 'demo'@'localhost' ;
  5. CREATE USER 'demo'@'%' IDENTIFIED BY 'demo' ;
  6. GRANT ALL PRIVILEGES ON *.* TO 'demo'@'%' WITH GRANT OPTION ;
  7. use mysql;
  8. update user set password=password('demo') where user='demo';
  9. flush privileges;
  10. exit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement