Skip to content

Instantly share code, notes, and snippets.

@jkanclerz

jkanclerz/sql create db & user

Last active August 29, 2015 14:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jkanclerz/ff837b1cfbfadf9e3d60 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jkanclerz/ff837b1cfbfadf9e3d60 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql create db & user
create database databasename;
create user 'user' identified by 'password';
grant all privileges on databasename.* to 'user'@localhost identified by 'password';
grant all privileges on databasename.* to 'user'@host;
grant all privileges on databasename.* to 'user'@%;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment