Jump to content

FeministWiki:Server setup: Difference between revisions

Line 279: Line 279:
  /root/bin/sql << EOF
  /root/bin/sql << EOF
  create user blogs@localhost identified by '$(cat ~/pwd/mysql-blogs)';
  create user blogs@localhost identified by '$(cat ~/pwd/mysql-blogs)';
create user feministfiles@localhost identified by '$(cat ~/pwd/mysql-files)';
create user feministforum@localhost identified by '$(cat ~/pwd/mysql-forum)';
create user feministmail@localhost identified by '$(cat ~/pwd/mysql-mail)';
create user feministwiki@localhost identified by '$(cat ~/pwd/mysql-wiki)';
create user fff@localhost identified by '$(cat ~/pwd/mysql-fff)';
EOF
Now grant them access to their corresponding databases.  Remember that this has to be done '''after''' the databases have been copied over:
/root/bin/sql << EOF
  grant all on blogs.* to blogs@localhost;
  grant all on blogs.* to blogs@localhost;
create user feministfiles@localhost identified by '$(cat ~/pwd/mysql-files)';
  grant all on feministfiles.* to feministfiles@localhost;
  grant all on feministfiles.* to feministfiles@localhost;
create user feministforum@localhost identified by '$(cat ~/pwd/mysql-forum)';
  grant all on feministforum.* to feministforum@localhost;
  grant all on feministforum.* to feministforum@localhost;
create user feministmail@localhost identified by '$(cat ~/pwd/mysql-mail)';
  grant all on feministmail.* to feministmail@localhost;
  grant all on feministmail.* to feministmail@localhost;
create user feministwiki@localhost identified by '$(cat ~/pwd/mysql-wiki)';
  grant all on feministwiki.* to feministwiki@localhost;
  grant all on feministwiki.* to feministwiki@localhost;
  grant all on feministwiki_de.* to feministwiki@localhost;
  grant all on feministwiki_de.* to feministwiki@localhost;
Line 297: Line 299:
  grant all on feministwiki_it.* to feministwiki@localhost;
  grant all on feministwiki_it.* to feministwiki@localhost;
  grant all on feministwiki_pt.* to feministwiki@localhost;
  grant all on feministwiki_pt.* to feministwiki@localhost;
create user fff@localhost identified by '$(cat ~/pwd/mysql-fff)';
  grant all on fff.* to fff@localhost;
  grant all on fff.* to fff@localhost;
  EOF
  EOF