Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @DATABASE='database';
- SET @USERNAME='username';
- SET @PASSWORD='password';
- SET @HOST='localhost';
- CREATE DATABASE @DATABASE;
- CREATE USER '@USERNAME'@'@HOST' IDENTIFIED BY '@PASSWORD';
- -- GRANT USAGE ON @DATABASE.* TO '@USERNAME'@'@HOST';
- GRANT ALL PRIVILEGES ON @DATABASE.* TO '@USERNAME'@'@HOST';
- FLUSH PRIVILEGES;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement