Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #create the new user
- CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
- #create the new database
- CREATE DATABASE newdatabase;
- #assign the user to it
- GRANT ALL PRIVILEGES ON newdatabase. * TO 'newuser'@'localhost';
- #flush
- FLUSH PRIVILEGES;
Add Comment
Please, Sign In to add comment