Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Show databases
- SHOW DATABASES;
- # Drop database
- DROP DATABASE {database};
- # Use database
- USE {database};
- # import database
- SOURCE {path to sql file on server}
- # create user
- CREATE USER '{user_name}'@'localhost' IDENTIFIED BY 'your_password';
- # Grant User Privileges
- GRANT ALL ON * TO 'new_user'@'localhost';
- # Flush Privileges
- FLUSH PRIVILEGES;
Add Comment
Please, Sign In to add comment