« FeministWiki:Server setup » : différence entre les versions

Ligne 222 : Ligne 222 :
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.  To do so, run this on the new server:
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.  To do so, run this on the new server:


  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)';
  grant all on blogs.* to blogs@localhost;
  grant all on blogs.* to blogs@localhost;