Skip to content

Instantly share code, notes, and snippets.

@Ikhiloya

Ikhiloya/CreateUser.sql

Created August 14, 2020 13:25
Show Gist options
  • Save Ikhiloya/97c0c11399ed4362917c30be4b155611 to your computer and use it in GitHub Desktop.
Save Ikhiloya/97c0c11399ed4362917c30be4b155611 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CreateUser.sql
create user 'sa'@'localhost' identified by 'sa1234'; -- Create the user
grant all on exercise1.* to 'sa'@'localhost'; -- Gives all privileges to that user on new db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment