Advertisement
Guest User

Untitled

a guest
Mar 9th, 2017
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SET @DATABASE='database';
  2. SET @USERNAME='username';
  3. SET @PASSWORD='password';
  4. SET @HOST='localhost';
  5.  
  6. CREATE DATABASE @DATABASE;
  7. CREATE USER '@USERNAME'@'@HOST' IDENTIFIED BY '@PASSWORD';
  8. -- GRANT USAGE ON @DATABASE.* TO '@USERNAME'@'@HOST';
  9. GRANT ALL PRIVILEGES ON @DATABASE.* TO '@USERNAME'@'@HOST';
  10. FLUSH PRIVILEGES;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement