FeministWiki:Server setup: Difference between revisions

    Line 219: Line 219:


    The {{C|check_perms}} command, which is part of GNU Mailman, will take care of fixing the group ownership of the extracted files.
    The {{C|check_perms}} command, which is part of GNU Mailman, will take care of fixing the group ownership of the extracted files.
    == Recreate SQL users ==
    If the versions of MariaDB on the old and new server are compatible enough, you might be able to dump the {{C|mysql.user}} table and import it on the new server, but it's safer to recreate the users from scratch:
    sql << EOF
    create user blogs@localhost identified by '$(cat ~/pwd/mysql-blogs)';
    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;
    create user fff@localhost identified by '$(cat ~/pwd/mysql-fff)';
    grant all on fff.* to fff@localhost;
    EOF


    == Test ==
    == Test ==