FeministWiki:Server setup: Difference between revisions

Line 279:

/root/bin/sql << EOF

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;

~~create user feministfiles@localhost identified by '$(cat ~/pwd/mysql-files)';~~

grant all on feministfiles.* to feministfiles@localhost;

~~create user feministforum@localhost identified by '$(cat ~/pwd/mysql-forum)';~~

grant all on feministforum.* to feministforum@localhost;

~~create user feministmail@localhost identified by '$(cat ~/pwd/mysql-mail)';~~

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_de.* to feministwiki@localhost;

Line 297:

Line 299:

grant all on feministwiki_it.* 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;

EOF