Guest User

Untitled

a guest
Nov 21st, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. # Show databases
  2. SHOW DATABASES;
  3.  
  4. # Drop database
  5. DROP DATABASE {database};
  6.  
  7. # Use database
  8. USE {database};
  9.  
  10. # import database
  11. SOURCE {path to sql file on server}
  12.  
  13. # create user
  14. CREATE USER '{user_name}'@'localhost' IDENTIFIED BY 'your_password';
  15.  
  16. # Grant User Privileges
  17. GRANT ALL ON * TO 'new_user'@'localhost';
  18.  
  19. # Flush Privileges
  20. FLUSH PRIVILEGES;
Add Comment
Please, Sign In to add comment