1,086
edits
FeministWiki:Server setup: Difference between revisions
→Recreate SQL users
Technician (talk | contribs) |
Technician (talk | contribs) |
||
| 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; | ||
grant all on feministfiles.* to feministfiles@localhost; | grant all on feministfiles.* to feministfiles@localhost; | ||
grant all on feministforum.* to feministforum@localhost; | grant all on feministforum.* to feministforum@localhost; | ||
grant all on feministmail.* to feministmail@localhost; | grant all on feministmail.* to feministmail@localhost; | ||
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; | ||
grant all on fff.* to fff@localhost; | grant all on fff.* to fff@localhost; | ||
EOF | EOF | ||