Skip to content

Instantly share code, notes, and snippets.

@larsvegas
Last active December 16, 2015 22:09
Show Gist options
  • Save larsvegas/5504851 to your computer and use it in GitHub Desktop.
Save larsvegas/5504851 to your computer and use it in GitHub Desktop.
create kconline user and databases
-- create database and user kconline
create database kconline;
grant usage on *.* to kconline@localhost identified by "kconline";
grant all privileges on kconline.* to kconline@localhost ;
-- create database and user kconline_test
create database kconline_test;
grant usage on *.* to kconline_test@localhost identified by "kconline_test";
grant all privileges on kconline_test.* to kconline_test@localhost ;
-- create database and user kconline_test
create database kconline_production;
grant usage on *.* to kconline_prod@localhost identified by "kconline_prod";
grant all privileges on kconline_production.* to kconline_prod@localhost ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment